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?
Could you share your app (with sample data) to let us investigate?
Hello,
Sorry for the delay, I've been very busy at work. Since I cannot share the original app, I had to create a new app and generate sample data.
It seems that the presence of the character '=' in dimension field of the bar chart is the problem. When I first add the dimension through qliksense UI, this issue doesn't happen. But if I add Month field by using the expression editor, it happens. In this case, I don't know how to solve this issue though, and any help would be much appreciated! 🙂
The screenshots and the app are attached.
This is ridiculous, i dont know how to explain but Qlik considers [Date.autoCalendar.YearMonth] and Date.autoCalendar.YearMonth as 2 different fields in selection.
Try changing your bar chart dimension to Date.autoCalendar.YearMonth then you will get your expected result.
Best
Yeah, just tried and worked. But why does qliksense behave like this if we're talking about the same field?
Let's say if I want the dimension field of the bar chart as
if(year(Date.autoCalendar.YearMonth) > 2016, Date.autoCalendar.YearMonth)
How can I define the set analysis in the KPI to ignore this particular selection?