Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ClementByr
Contributor III
Contributor III

Show number of null value in a Bar Chart

Hello,

I have enable a bar chart to show the null value which is represented by a grey bar.

But, I can not see the popup that contains the total number of null in the bar chart.

However, the popup does appear with no problem for the null values in the pie chart.

Does anyone know how to see the number of null value in a bar chart, please ?

Best regards,

Clément Boyer

Labels (4)
4 Replies
sunny_talwar

Would you be able to share a sample where we can see the issue?

ClementByr
Contributor III
Contributor III
Author

Hello Sunny,

Yes, of course, you can try with this sample :

Machine_IDDateNum_Incident
12016101452400
12016101452406
12016101452000
12016101452447
1 101452451
12016101452452
12016101452496
12017101452000
12017101452591
1 101452597
12018101452601
12018101452614
12019101452621
22017101452000
22017101452682
22017101452690
22017101452829
2 101452835
22017101452842
22017101452843
22018101452000
22018101452907
22019101452911
22019101452915
22019101452916
22019101452918
2 101452000
22019101452922
22019101452923
22019101452924
22019101452928
32018101452940
32018101452941
32018101452944
3 101452000
32018101452961
32018101453035
32018101453000
32018101453042
32019101453048

 

I am trying to count Machine_ID by Date in a bar chart. You will get normally 5 null values, but I need to see the number in a popup when I hover my mouse pointer on the grey null bar.

Thanks.

prabhu0505
Specialist
Specialist

Used below expression and changed Number formatting -> Measure Expression

Dual (Text(If (IsNull(Date)=-1, Count(Machine_ID), Count(Machine_ID)&'-'& Concat(Distinct Machine_ID,','))), Count(Machine_ID))

 

clipboard_image_0.png

ClementByr
Contributor III
Contributor III
Author

Hi Prahbu,

I can see what you propose as solution, this can be very useful, thank you.

However, I tried your code with the formatting option and the null bar is still grey and not showing any value. Putting the null value as a part of the measure is a good track, I will continue to figure out a solution.

Best regards