Chart dimension selecting KPI even with set analysis

[arturmesquitab]

Hello,

I have a KPI with the following expression:

count({<[Status]={'Active'},Month=>} user_id)

Also a bar chart where:

• Dimension: Month
• Measure: count(user_id)

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?

[tresesco]

Could you share your app (with sample data) to let us investigate?

[arturmesquitab]

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.

[Quy_Nguyen]

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

[arturmesquitab]

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?