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: 
QlickySense
Creator
Creator

Discrepancies between charts/expressions

Hello,

I've got a pie chart with its numbers and % (used count and ticket relative option for one expression, for the other only count)

I wanted to change it to bar chart and highlight value (percentage)

My formula is 

DUAL(Num(count( {<MyVar1 *= {1}>} MyVar1),'#.') & ' (' & Num(count( {<MyVar1 *= {1}>} MyVar1)/count(TOTAL MyVar1 *= {1}>} MyVar1),'0.0%')&')',count( {<MyVar1 *= {1}>}MyVar1))

I can see slight discrepancies between charts in percentage

Pie chart (its accurate)

Cat13.3%22
Cat26.2%42
Cat316.7%113
Cat416.0%108
Cat557.8%391


Bar chart

Cat122 (3.2%)
Cat242 (6.0%)
Cat3113 (16.2%)
Cat4108 (15.5%)
Cat5391 (56.0%)


Looks like DUAL expression takes into consideration null values, because there is 3.2% for full values and when I add that, then its 100%. 

 

Labels (3)
0 Replies