- Видео 166
- Просмотров 243 583
Qlik-it Analytics
Великобритания
Добавлен 28 май 2007
This is a dedicated channel to Qlik.
This is not linked to any company or not backed by Qlik in any way. This is just my personal effort to give back to the community. None of the opinion shared here is related to any official statement from company.
You can follow me or contact me on Linkedin: www.linkedin.com/in/madnanrafiq/
This is not linked to any company or not backed by Qlik in any way. This is just my personal effort to give back to the community. None of the opinion shared here is related to any official statement from company.
You can follow me or contact me on Linkedin: www.linkedin.com/in/madnanrafiq/
Qlik Sense Using formula to Customise number format
The formatting functions impose the display format on the input numeric fields or expressions, Depending on data type, you can specify the characters for the decimal separator, thousands separator, and so on. However, the challenge occurs when units such as currencies or symbols change in every row. Either you can add a different column to show it or better use Measure Expression in number formatting dropdown and write your own format.
Expression gives a lot of flexibility to experiment and write conditions and much more.
I hope you enjoy this video.
Expression gives a lot of flexibility to experiment and write conditions and much more.
I hope you enjoy this video.
Просмотров: 325
Видео
Qlik Sense Currency: Single dashboard for multiple regions
Просмотров 2243 месяца назад
#multicurrency dashboards are aimed to accommodate analysis need on regional users who are different #regions, providing a more inclusive and user-friendly experience. A multicurrency dashboard lets users look at same analytics and insights based on their role and region. Eg. if you are UK, you might want to look data in GBP but regional director in Europe might want to look at number in Euro. ...
Qlik Sense Multilingual: Work with language you prefer
Просмотров 3754 месяца назад
#Multilingual dashboards are aimed to accommodate users who speak different #languages, providing a more inclusive and user-friendly experience. A multilingual dashboard lets users interpret analytics and insights in their #preferred and #locallanguage. In #Qlik its very easy to create, a multiple-language dashboard in a familiar setting.
Talend Tutorial: How to schedule the data flow
Просмотров 1976 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place. Talend offers a Data Trust Score to help you make better decisions based on high-quality data. Start your free cloud trial of Talend today - including Data Inventory - and discover how easy it is to achieve clean, complete, and compliant data.
Talend Tutorial: Data Stewardship Campaigns and validation
Просмотров 3366 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place. Talend offers a Data Trust Score to help you make better decisions based on high-quality data. It empowers data stewards-individuals responsible for maintaining data quality and governance-to efficiently oversee data management processes. It gives the power to improve the quality of actions and create golden r...
Talend Tutorial: Pipeline Designer
Просмотров 3226 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place.Talend offers a Data Trust Score to help you make better decisions based on high-quality data. Pipeline designer is a cloud-native visual design tool for designing, deploying, and managing data pipelines. It allows users to connect to various data sources, transform data, and deliver it to target destinations w...
Talend Tutorial: Attributes how to make data discoverable and popular
Просмотров 866 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place.Talend offers a Data Trust Score to help you make better decisions based on high-quality data. Talend Discoverability and Popularity are features within Talend’s Data Inventory application designed to enhance data management by making data assets more accessible and understood across an organization. Start your...
Talend Tutorial: Data preparation
Просмотров 3006 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place.Talend offers a Data Trust Score to help you make better decisions based on high-quality data. Preparation is a tool designed to simplify the process of preparing data for analysis, reporting, or other data-driven tasks. It allows users to clean, transform, and enrich data efficiently, ensuring that it is in th...
Talend Tutorial: How to add custom Semantics
Просмотров 1256 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place.Talend offers a Data Trust Score to help you make better decisions based on high-quality data. Data semantic is one of the best way to check data quality and validity of the data in your dataset. It also assist all user to standardise data. As part of governance, we can edit existing semantics or add new. Start...
Talend Tutorial: Data Inventory and onbaording data
Просмотров 1736 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place.Talend offers a Data Trust Score to help you make better decisions based on high-quality data. Data inventory covers key topics such as Trust score and its parameters. First step in the process to on board the data Start your free cloud trial of Talend today - including Data Inventory - and discover how easy it...
Talend Tutorial: Product Tour first time login
Просмотров 1876 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place.Talend offers a Data Trust Score to help you make better decisions based on high-quality data. Start your free cloud trial of Talend today - including Data Inventory - and discover how easy it is to achieve clean, complete, and compliant data.
Talend how to activate Talend Cloud Trial
Просмотров 2016 месяцев назад
Talend Cloud hears a lot but Doesn't know where to start? You are at the right place.Talend offers a Data Trust Score to help you make better decisions based on high-quality data. Start your free cloud trial of Talend today - including Data Inventory - and discover how easy it is to achieve clean, complete, and compliant data.
Qlik Sense Basic Training Workshop Tutorial
Просмотров 5156 месяцев назад
This is recorded version of Qlik Training conducted in Jul 2024. This training covers the basics for people who just want to get started and get familarised. It is hand for Business analyst. #qliksense #businessintelligence #business #Qlikbasic #qlik_tutorial #QlikSense #Qlik_Start Files used in the training can be found on this link. docs.google.com/spreadsheets/d/1wKqrvZIA7W-LL45gE6jtfGznxxik...
Qlik Now vs Localtime function: Bonus Today function
Просмотров 976 месяцев назад
In Qlik (Sense and View), #Now() and #Localtime() give very similar results, but they are different from each other in certain ways. Both these functions give current time. #Now always returns GMT time, whereas #Localtime returns #location time. Some parameters in NOW() can be used to get different important time in #Qlik than current such as #lastrealodtime, #timebeforelast reload #usersession...
Qlik Sense Cloud Activate new App analyser
Просмотров 2546 месяцев назад
Qlik Sense Cloud offers a variety of pre-built Monitoring Applications. These Monitoring Apps can provide crucial insights, such as identifying which users are accessing specific applications, the duration of their sessions, which sheets they interact with, the time spent on each sheet, and how frequently they navigate between sheets. They also help you keep track of your reload schedules and a...
Qlik combine mulple files with different structures automatically
Просмотров 2936 месяцев назад
Qlik combine mulple files with different structures automatically
Qlik Cloud: How to join the request on a tenant Updated
Просмотров 706 месяцев назад
Qlik Cloud: How to join the request on a tenant Updated
Qlik Peek Function for missing values
Просмотров 77810 месяцев назад
Qlik Peek Function for missing values
Qlik Sense Cloud Reporting PDF as output
Просмотров 29710 месяцев назад
Qlik Sense Cloud Reporting PDF as output
Qlik Sense Cloud Reporting Scheduling Report with Advance Filters Tutorial
Просмотров 494Год назад
Qlik Sense Cloud Reporting Scheduling Report with Advance Filters Tutorial
Qlik Sense Cloud Reporting Scheduling report through email template Tutorial
Просмотров 960Год назад
Qlik Sense Cloud Reporting Scheduling report through email template Tutorial
Qlik Sense Tips for better performance Turn-off Search Index
Просмотров 407Год назад
Qlik Sense Tips for better performance Turn-off Search Index
Qlik Sense Cloud Reporting Levels and Pages (Iterating Field Values)
Просмотров 347Год назад
Qlik Sense Cloud Reporting Levels and Pages (Iterating Field Values)
Qlik Sense Cloud Reporting Adding data Table in Detail Tutorial
Просмотров 536Год назад
Qlik Sense Cloud Reporting Adding data Table in Detail Tutorial
Qlik Sense Cloud Reporting Configuration (End to End starting Guide)
Просмотров 462Год назад
Qlik Sense Cloud Reporting Configuration (End to End starting Guide)
Qlik Sense Cloud Reporting Charts as image
Просмотров 215Год назад
Qlik Sense Cloud Reporting Charts as image
Qlik Sense Layout Container Tutorial
Просмотров 2,3 тыс.Год назад
Qlik Sense Layout Container Tutorial
Hi Sir, I have Zipcodes and a manual area column, how can I achieve with zipcodes ? Let me know if we can connect.
I am if you can charge any amount for your guidance.
Fantastic, thank you so much!!!!
Thanks a lot my friend
Why I can't find talend data catalog within the apps provided from talend in this free trial ?
I have like oct 24 and nov 24 how cna i get latest
Hi you can do the same for Month Column, Usually issue is in Monthyear columns at the backend sometime you are getting date not Month. To avoid any confusion, create new column in script Year(Date)&num(Month(Date),'00'). This will always give Month in YYYYMM format. Then you can use Max function.
Does it work while adding reference line?
Yes, it does work in reference line
Hi can u please share end to end project in qlik
Hi you can look into my channel. I have end to end training available in there
Please send me the data.
drive.google.com/drive/folders/1WOLNz2HLuXV3kwc357JXGhKaWy8RfeWt?usp=sharing
La opción de agregar un gráfico a través de las herramientas- personalizado no está para todos😢
Nothing like this on RUclips , Thank you for your in-depth knowledge share.
In my report, within Qlik, it is always filtered to the current month, but when I export it to Excel, it removes all the filters.
Hello! I have a report that I need to automate sending, which contains historical information (sales since 2018) up to the current date. This report needs to be sent daily, showing only the sales performance for the current month. To do this, would I always need to apply a filter for the month I'm referring to in the "Filters" tab? This would be very time-consuming, as I would need to adjust the filter at the beginning of every month. Is there any other way to do this?
thank yoy
thanks
thank you
thanks
Thank you
Thank you
great thanks
thanks a lot
thank you
Appriciate ✌
Where to get Datasets
Here you go drive.google.com/drive/u/0/folders/1WOLNz2HLuXV3kwc357JXGhKaWy8RfeWt
Can you help me ,i am having longitide and latitude and i want to show an area in map which should have boundary
Hi, Can you advice how to show 2 digit percentage in pie chart in qlik Sense. Cause i already change in Measures>Number formatting(Number)>12.34% Or Number formatting(Custom)>#,##0.00%. But Still got only 1 digit. Thank in advance.
Hi, number format that you change will only impact if you have following settings: Properties> Appearance> Presentation>Value Label> Custom> Value By defualt it's share, and format for that is fixed. Unfortunately, if you want to change formating of share, that to my knowledge is not possible in standard. However, you can create a tooltip expression to show that percentage.
Hi. Is it possible to assign a dynamic report and file name based upon the filtered values? Is it possible to use variables within the report and file name?
Not yet
Nicely Explained👍
Can not be store on oneDrive
Can we link our outlook mail to get notification the status of reload task ??
Hi Maya, I was away for sometime, so missed this question. Yes, you can do that, if you have setup smtp settings on server. Even you can send an alert with data in app.
Please make section access & section application
Hi I already have a section access video on my channel. You can check there
Possible set analysis question how to solve
You can connect with me on Linkedin. I will try if i can give you some idea about your problem
We need development tablea & pivot table difference impt question in every interview need in pratical
I think you are updated wrong video or wrong subject name
can we add charts and table column from two different app in qliksense excel add in ? please reply its urgent
No. Currently it only support one app. It's app specific. You need to get around adding in it one app
@@adnan5339qlik ok thank you. is there any other way i can do this
Hello, in prepare section cant see REPORT option, is there any different license that I must have ?
Which version of Qlik you are using, Cloud or on Premis? It is available only on cloud, you don't need special license, just need a proper role
Can you help me how to handle more than 100,000 cells while exporting it via an API?
Hi, can't thank you enought this was quite helpful, Thank you
Ojalá puedas poner subtitulos en español
Hi there is English version here ruclips.net/video/5Y_FpZYwJu4/видео.html Auto translate feature in Captions might help. If you specific query, you can approach me on Linkedin. I will try to help if I can.
Hi sir, can you please help how can i add data labels in Line Chart?
Thank you very much this just helped me at work! :)
That's Conclude my ANSWER 😄
Cool, very useful, carry on.
I hope you have recovered from that flu
Nice..how you got that emojies ?
You can copy-paste from anysource. Like your WhatsApp chat. Although for this video, I had feature in my keyboard.
@@adnan5339qlik I have seen max videos of yours...I felt it's very useful and i learnt many things....well done bro...
@@adnan5339qlik can u do videos on tips and tricks shortcuts ...so that it wil be helpful for interviews...
Thanks a lot for your appreciation.
Yes. I am planning on that. And also Replicate + Talend
Thank you !
Подскажите пожалуйста, как сделать агрегацию данных по уровням. Чтобы на уровне 1 была сумма значений 1, 2, 3 на уровне 2 сумма 1, 2, 3 на уровне 3 - 3.
There multiple ways to do it. Depend on where you want to do it. On Front end its very simple, you can use Pivot table. If you want to do it in scripting, then after creating hierarchy, you need to join hierarchy table with transaction table (Table which has field that you want to aggr), then either you can use window function or aggr group by function. Check my video (Windows function) it has covered that part.
Where is the vfile logic ?
Hi Sam, please this video in the series ruclips.net/video/Hq7SKNgXjxo/видео.html
Do you have any paid full course on Qlik Admin part, especially Security Rule , custom property , basically everything related to QMC?
Hi Harish, Not at the moment.
Can you help me with a similar scenario, like when the user opens the qliksense dashboard by default it should show yesterday's date data
Hi there, better way to do it would be create a yesterday flag in script. Like if date = today - 1 then 1 else 0 then use this field for default selection using bookmarks.