Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
arturmesquitab
New Contributor

Chart dimension selecting KPI even with set analysis

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?

13 Replies

Re: Chart dimension selecting KPI even with set analysis

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
arturmesquitab
New Contributor

Re: Chart dimension selecting KPI even with set analysis

Yes, I did, but that's why I don't understand: why is bar chart selection affecting the KPI?

Luminary
Luminary

Re: Chart dimension selecting KPI even with set analysis

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

rangam_s
Contributor II

Re: Chart dimension selecting KPI even with set analysis

Have you used same field as dimension in bar-chart?

arturmesquitab
New Contributor

Re: Chart dimension selecting KPI even with set analysis

Yes, as described in the question

arturmesquitab
New Contributor

Re: Chart dimension selecting KPI even with set analysis

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.

arturmesquitab
New Contributor

Re: Chart dimension selecting KPI even with set analysis

Just got the information about the version: June 2018, 12.26.01

Re: Chart dimension selecting KPI even with set analysis

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Luminary
Luminary

Re: Chart dimension selecting KPI even with set analysis

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