Discussion board where members can get started with Qlik Sense.
I have Bar char and KPI.
Initially the KPI shows total number but if i selected any of the particular category if always shows zero.
Can you please help me on this.
Bar chart expression :
=if([days] <=7, '0-7 Days'
,if([days] <=30, '8-30 Days'
,if([days] <=60, '31-60 Days'
,if([days] <=90, '61-90 Days'
, 'Over 90 days'
KPI Expression : SUM([Total Discharges])
Thanks in advance.
what is the measure in bar chart ?
do you have multiple tables in script? if yes mention the flag in KPI
Count([Re-admit Days]) for Bar charts
please check your data-model/script
or try bucket calc in backend-script
ok let me try
check whether you have any values for the days <=7 [Total Discharges] in this column
I would not do that calculation in the bar chart. I would do it in your load script and store the value in a field. Then simply do a count in the bar chart and in the KPI.
Much more efficient and less code to deal with in the dashboard.