Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a KPI with the following expression:
count({<[Status]={'Active'},Month=>} user_id)
Also a bar chart where:
And finally a filter for the dimension Month.
When one of the months is selected in the filter, the KPI is not affected, as expected with the set analysis. But when I do it in the bar chart, the KPI is affected. Isn't it supposed to have the same behavior as the filter pane?
You already restricted the Month field in analysis. Where you can try this as well
Count({1} user_id)
Or
Either you can try this using Work around?
Load Month as %Month From Table;
And use %Month as your List box and start select and it won't effect to selection panel as it will disable.
Yes, I did, but that's why I don't understand: why is bar chart selection affecting the KPI?
Hi Artur,
when making selections in filter pane vs. bar chart, are you selecting exact same months? No other selections or dimensions in that bar chart? Plus, what version of Qlik Sense are you using?
Juraj
Have you used same field as dimension in bar-chart?
Yes, as described in the question
I cannot give your the information about the version right now, but I think it's the one right after the June 2017 Patch 1.
So, the dimensions are the same and no other selection has been made. Also, when I select one bar, qliksense shows a selection applied to the field [Month], which is the same dimension present in the KPI and the bar chart.
Just got the information about the version: June 2018, 12.26.01
Hi,
Can you provide little bit more information about your both chart
Chart 1 : dimension, measure(with expression)
Chart 2 : dimension, Measure(with expression)
List box on which you are selecting data.
also, If possible share screen shot of charts
Regards,
Hi Artur,
if you have a possibility, test the app on a different version and see if this occurs on different version as well. I did not work much with June 2018 so far, but I hear it can show some unexpected behavior...
Juraj