Qlik-it Analytics
Qlik-it Analytics
  • 166
  • 214 439
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.
Переглядів: 57

Відео

Qlik Sense Multilingual: Work with language you prefer
Переглядів 717 годин тому
#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
Переглядів 17621 день тому
#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
Переглядів 1402 місяці тому
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
Переглядів 1552 місяці тому
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
Переглядів 1412 місяці тому
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
Переглядів 452 місяці тому
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
Переглядів 1142 місяці тому
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
Переглядів 522 місяці тому
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
Переглядів 562 місяці тому
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
Переглядів 762 місяці тому
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
Переглядів 842 місяці тому
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
Переглядів 3002 місяці тому
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
Переглядів 852 місяці тому
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
Переглядів 1963 місяці тому
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
Переглядів 2323 місяці тому
Qlik combine mulple files with different structures automatically
Qlik Cloud: How to join the request on a tenant Updated
Переглядів 563 місяці тому
Qlik Cloud: How to join the request on a tenant Updated
Qlik Sense Cyclic Group
Переглядів 6785 місяців тому
Qlik Sense Cyclic Group
Qlik Peek Function for missing values
Переглядів 6157 місяців тому
Qlik Peek Function for missing values
Qlik Sense Cloud Reporting PDF as output
Переглядів 2377 місяців тому
Qlik Sense Cloud Reporting PDF as output
Qlik Sense Cloud Reporting Scheduling Report with Advance Filters Tutorial
Переглядів 4068 місяців тому
Qlik Sense Cloud Reporting Scheduling Report with Advance Filters Tutorial
Qlik Sense Cloud Reporting Scheduling report through email template Tutorial
Переглядів 6638 місяців тому
Qlik Sense Cloud Reporting Scheduling report through email template Tutorial
Qlik Sense Tips for better performance Turn-off Search Index
Переглядів 3168 місяців тому
Qlik Sense Tips for better performance Turn-off Search Index
Qlik Sense Cloud Reporting Levels and Pages (Iterating Field Values)
Переглядів 2558 місяців тому
Qlik Sense Cloud Reporting Levels and Pages (Iterating Field Values)
Qlik Sense Cloud Reporting Adding data Table in Detail Tutorial
Переглядів 4259 місяців тому
Qlik Sense Cloud Reporting Adding data Table in Detail Tutorial
Qlik Sense Cloud Reporting Configuration (End to End starting Guide)
Переглядів 3209 місяців тому
Qlik Sense Cloud Reporting Configuration (End to End starting Guide)
Qlik Sense Cloud Reporting Charts as image
Переглядів 1719 місяців тому
Qlik Sense Cloud Reporting Charts as image
Qlik Sense Cloud Reporting (Overview)
Переглядів 2379 місяців тому
Qlik Sense Cloud Reporting (Overview)
Qlik Sense Layout Container Tutorial
Переглядів 1,8 тис.9 місяців тому
Qlik Sense Layout Container Tutorial
Qlik Sense New Pivot Table
Переглядів 3,6 тис.9 місяців тому
Qlik Sense New Pivot Table

КОМЕНТАРІ

  • @techskills3761
    @techskills3761 2 дні тому

    Hi can u please share end to end project in qlik

    • @adnan5339qlik
      @adnan5339qlik 2 дні тому

      Hi you can look into my channel. I have end to end training available in there

  • @shailenderojha8282
    @shailenderojha8282 4 дні тому

    Please send me the data.

    • @adnan5339qlik
      @adnan5339qlik 4 дні тому

      drive.google.com/drive/folders/1WOLNz2HLuXV3kwc357JXGhKaWy8RfeWt?usp=sharing

  • @gabrielahormazaballopez6595
    @gabrielahormazaballopez6595 6 днів тому

    La opción de agregar un gráfico a través de las herramientas- personalizado no está para todos😢

  • @darshanrathod1286
    @darshanrathod1286 18 днів тому

    Nothing like this on UA-cam , Thank you for your in-depth knowledge share.

  • @ArthurWeber-z6l
    @ArthurWeber-z6l 19 днів тому

    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.

  • @ArthurWeber-z6l
    @ArthurWeber-z6l 19 днів тому

    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?

  • @johannespkassing
    @johannespkassing 23 дні тому

    thank yoy

  • @johannespkassing
    @johannespkassing 23 дні тому

    thanks

  • @johannespkassing
    @johannespkassing 23 дні тому

    thank you

  • @johannespkassing
    @johannespkassing 23 дні тому

    thanks

  • @johannespkassing
    @johannespkassing 23 дні тому

    Thank you

  • @johannespkassing
    @johannespkassing 23 дні тому

    Thank you

  • @johannespkassing
    @johannespkassing 23 дні тому

    great thanks

  • @johannespkassing
    @johannespkassing 23 дні тому

    thanks a lot

  • @johannespkassing
    @johannespkassing 23 дні тому

    thank you

  • @nomananjum95
    @nomananjum95 24 дні тому

    Appriciate ✌

  • @sz6618
    @sz6618 28 днів тому

    Where to get Datasets

    • @adnan5339qlik
      @adnan5339qlik 28 днів тому

      Here you go drive.google.com/drive/u/0/folders/1WOLNz2HLuXV3kwc357JXGhKaWy8RfeWt

  • @vivekkumar-ct7rb
    @vivekkumar-ct7rb Місяць тому

    Can you help me ,i am having longitide and latitude and i want to show an area in map which should have boundary

  • @pym3434
    @pym3434 Місяць тому

    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.

    • @adnan5339qlik
      @adnan5339qlik 28 днів тому

      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.

  • @adriaanvanniekerk1789
    @adriaanvanniekerk1789 Місяць тому

    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?

  • @InspireHub19
    @InspireHub19 Місяць тому

    Nicely Explained👍

  • @sasonikolovski4595
    @sasonikolovski4595 Місяць тому

    Can not be store on oneDrive

  • @Maya-mayura
    @Maya-mayura 2 місяці тому

    Can we link our outlook mail to get notification the status of reload task ??

    • @adnan5339qlik
      @adnan5339qlik 28 днів тому

      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.

  • @Dollyrana2498
    @Dollyrana2498 2 місяці тому

    Please make section access & section application

    • @adnan5339qlik
      @adnan5339qlik 2 місяці тому

      Hi I already have a section access video on my channel. You can check there

  • @Dollyrana2498
    @Dollyrana2498 3 місяці тому

    Possible set analysis question how to solve

    • @adnan5339qlik
      @adnan5339qlik 2 місяці тому

      You can connect with me on Linkedin. I will try if i can give you some idea about your problem

  • @Dollyrana2498
    @Dollyrana2498 3 місяці тому

    We need development tablea & pivot table difference impt question in every interview need in pratical

  • @aquibchauhan3810
    @aquibchauhan3810 3 місяці тому

    I think you are updated wrong video or wrong subject name

  • @her_messylife
    @her_messylife 3 місяці тому

    can we add charts and table column from two different app in qliksense excel add in ? please reply its urgent

    • @adnan5339qlik
      @adnan5339qlik 3 місяці тому

      No. Currently it only support one app. It's app specific. You need to get around adding in it one app

    • @her_messylife
      @her_messylife 3 місяці тому

      @@adnan5339qlik ok thank you. is there any other way i can do this

  • @RodrigoOlmedo-r1b
    @RodrigoOlmedo-r1b 4 місяці тому

    Hello, in prepare section cant see REPORT option, is there any different license that I must have ?

    • @adnan5339qlik
      @adnan5339qlik 3 місяці тому

      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

  • @MayurSahu-pc3bm
    @MayurSahu-pc3bm 4 місяці тому

    Can you help me how to handle more than 100,000 cells while exporting it via an API?

  • @nicouekuete5564
    @nicouekuete5564 4 місяці тому

    Hi, can't thank you enought this was quite helpful, Thank you

  • @gabrielahormazaballopez6595
    @gabrielahormazaballopez6595 4 місяці тому

    Ojalá puedas poner subtitulos en español

    • @adnan5339qlik
      @adnan5339qlik 4 місяці тому

      Hi there is English version here ua-cam.com/video/5Y_FpZYwJu4/v-deo.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.

  • @shivaniprasad7120
    @shivaniprasad7120 4 місяці тому

    Hi sir, can you please help how can i add data labels in Line Chart?

  • @ssninesix
    @ssninesix 5 місяців тому

    Thank you very much this just helped me at work! :)

  • @nomananjum95
    @nomananjum95 5 місяців тому

    That's Conclude my ANSWER 😄

  • @sapboxi
    @sapboxi 5 місяців тому

    Cool, very useful, carry on.

  • @JorgePrieto-lj5yw
    @JorgePrieto-lj5yw 6 місяців тому

    I hope you have recovered from that flu

  • @sureshg587
    @sureshg587 6 місяців тому

    Nice..how you got that emojies ?

    • @adnan5339qlik
      @adnan5339qlik 6 місяців тому

      You can copy-paste from anysource. Like your WhatsApp chat. Although for this video, I had feature in my keyboard.

    • @sureshg587
      @sureshg587 6 місяців тому

      @@adnan5339qlik I have seen max videos of yours...I felt it's very useful and i learnt many things....well done bro...

    • @sureshg587
      @sureshg587 6 місяців тому

      @@adnan5339qlik can u do videos on tips and tricks shortcuts ...so that it wil be helpful for interviews...

    • @adnan5339qlik
      @adnan5339qlik 6 місяців тому

      Thanks a lot for your appreciation.

    • @adnan5339qlik
      @adnan5339qlik 6 місяців тому

      Yes. I am planning on that. And also Replicate + Talend

  • @ricardoveloso9163
    @ricardoveloso9163 6 місяців тому

    Thank you !

  • @Мария-ф1з7б
    @Мария-ф1з7б 7 місяців тому

    Подскажите пожалуйста, как сделать агрегацию данных по уровням. Чтобы на уровне 1 была сумма значений 1, 2, 3 на уровне 2 сумма 1, 2, 3 на уровне 3 - 3.

    • @adnan5339qlik
      @adnan5339qlik 7 місяців тому

      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.

  • @samkaran6351
    @samkaran6351 7 місяців тому

    Where is the vfile logic ?

    • @adnan5339qlik
      @adnan5339qlik 7 місяців тому

      Hi Sam, please this video in the series ua-cam.com/video/Hq7SKNgXjxo/v-deo.html

  • @harishkumar-ni4jb
    @harishkumar-ni4jb 7 місяців тому

    Do you have any paid full course on Qlik Admin part, especially Security Rule , custom property , basically everything related to QMC?

    • @adnan5339qlik
      @adnan5339qlik 7 місяців тому

      Hi Harish, Not at the moment.

  • @vamsiakhil9325
    @vamsiakhil9325 7 місяців тому

    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

    • @adnan5339qlik
      @adnan5339qlik 7 місяців тому

      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.

  • @RimantasEndriukaitis
    @RimantasEndriukaitis 8 місяців тому

    I hate learning videos where teacher does not have clear scenario is jumping back ang forth chaotically. -1

  • @Виктор-ш5к
    @Виктор-ш5к 8 місяців тому

    Thank you this is what I was looking for

  • @jyothsnashetty7322
    @jyothsnashetty7322 8 місяців тому

    I added 2 sql script, but when I goto data model I see only one bubble

    • @adnan5339qlik
      @adnan5339qlik 8 місяців тому

      It's most likely both table have same column. Qlik do auto concatenate (union) if 2 table are exactly same structure

  • @simonheap5654
    @simonheap5654 8 місяців тому

    I'm badly missing the Expand all/Collapse all in the contextual menu. Why has that gone missing? I even had my hopes so high that I was hoping the good old Qlikview feature of being able to expand or collapse to a certain level of the dimensions... please could we have these features back?

  • @ruchirhodes6098
    @ruchirhodes6098 8 місяців тому

    Could you help walk us through on how some of these charts are created? This is a great resource. Thank you.

    • @adnan5339qlik
      @adnan5339qlik 8 місяців тому

      Hi Ruchi, I will try to walk through them in next blogs

  • @raginiminivlogger
    @raginiminivlogger 9 місяців тому

    can i have the file which you use