Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am a beginner in Qlik Sense. Since I am working on a huge dataset, I am aggregating the values before importing it in Qlik Sense to improve the performance. Now, I wish to only display a pre-aggregated field in a KPI chart. Below are the options that I get while adding a new measure to the KPI chart.
If I forcefully edit the expression to remove the aggregation, it does not display any value.
My aggregated table now looks like this:
So I plan to have a Filter panes for Year and Gender and KPI chart or Patient Count.
Can anybody kindly suggest a work around?
Any help will be greatly appreciated! Thanks!
It's not possible to show value without aggregation in KPI. Either you can store the value in variable via load script and call that variable in KPI or use aggregation functions to show specific value in KPI
I understand the goal of what you are trying to accomplish... But this isn't what Qlik does natively.
Would it be possible to adjust your aggregate table into something like
Year | gender | countNewPatients | countRepeatPatients
Do you think that would work? I think this would make it easier to make your KPI perform as expected.
I would recommend two KPIs then, one to display unique patient counts, and the other total patient counts?
Sorry for formatting, responding from my phone.