Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaushik2020
Creator III
Creator III

Bar Chart with user defined measure

Hello Everyone, 

I have below dimension and measure.

Dimension:- Channel_Name

Measure:-

Num(count({$<Year=, Month=, Day=,AnswerType={'Main'},Score={'4','5'},QuestionType={'CSAT'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
distinct CONTRACT_ID)

/
count({$<Year=, Month=, Day=,AnswerType={'Main'},QuestionType={'CSAT'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
distinct Total<Channel_Name>CONTRACT_ID),'#,##0.0%')

Below is currently how the bar chart looks like. 

kaushi2020_0-1708001239305.png

If i just add Channel Name as dimension and the measure expression by default above is the outcome. 

 

Here I want to show bar length based on 2 different measures. 

Measure 1 => default which I have shared above. It should bar length based on the measure calculation. 

Measure 2 => want to add 2 more conditions as a set expressions to the existing one to show the length of the bar. 

How I can do this ? 

Thanks in advance. 

 

2 Replies
theoat
Partner - Specialist
Partner - Specialist

Yes it is possible.
You can add another measure.

Capture d'écran 2024-02-15 141917.pngCapture d'écran 2024-02-15 141922.png

Kind regards,
Théo ATRAGIE.

Kaushik2020
Creator III
Creator III
Author

Thanks a lot for your approach. By adding 2 measure and 1 dimension, you will get 2 grouped charts based on the existing dimension. But in my case I want to show only 2 bars which should ideally show the custom calculation.

kaushi2020_0-1708348670046.png

To show custom measure %, I just deleted the dimension and added 2 master items (using master items enables me to add custom colours for the bars)

kaushi2020_1-1708348751929.png

With this approach, I will still show only 2 bars even when I have multiple values in Dimension. 

also the calculation for each bar is based on the Master item 🙂 

 

Thanks Again