topic Re: Chart is not ignoring selection in QlikView

Chart is not ignoring selection

inescastelhano — Fri, 13 May 2016 13:41:55 GMT

Hello

I have a qlik dashboard where i have the following data:

Client Unit Value Year

1 A 30 2016

1 B 30 2016

1 C 10 2016

2 A 10 2016

2 B 15 2016

2 C 25 2016

3 A 25 2016

3 B 25 2016

3 C 15 2016

1 A 40 2015

1 B 40 2015

1 C 20 2015

...

I want to have a chart displaying: for each client, the unit with the greatest value (and respective value), per year.

The expression I'm using is:

if(aggr(rank(Max({<[Flag_doesn't_matter]={T}>}Value))<=1,[Client],Year,[Unit]),

sum({<[Flag_doesn't_matter={T}>}Value))

and my dimensions are: Client, Year, Unit.

However, my chart shows as follows, which means, it does not consider all years if i don't have all the years selected. At the moment, only 2016 is selected.

If I select 2015 and 2016, it shows as follows (this is what i want, even having only 2016 selected - I want ALL years):

I don't know how to make the chart to show all years. Thanks in advance.

Re: Chart is not ignoring selection

trdandamudi — Fri, 13 May 2016 13:44:28 GMT

Give a try with the below:

if(aggr(rank(Max({1<[Flag_doesn't_matter]={T}>}Value))<=1,[Client],Year,[Unit]),

sum({<[Flag_doesn't_matter={T}>}Value))

Re: Chart is not ignoring selection

sunny_talwar — Fri, 13 May 2016 13:46:40 GMT

Would you be able to share a sample to look at the issue?

Re: Chart is not ignoring selection

inescastelhano — Fri, 13 May 2016 13:47:54 GMT

Does not work

Re: Chart is not ignoring selection

inescastelhano — Fri, 13 May 2016 14:20:55 GMT

Here it is.

Re: Chart is not ignoring selection

sunny_talwar — Fri, 13 May 2016 14:23:07 GMT

I am seeing this without selection. Is this not what you are seeing?

Re: Chart is not ignoring selection

jonathandienst — Fri, 13 May 2016 14:26:20 GMT

The Aggr() function also responds to current selections, so the data is already reduced to the selected year before the year override is applied.

Do you really need the Aggr() here? If you modify the expression to avoid using Aggr, then you will be able to see all years.

Re: Chart is not ignoring selection

jonathandienst — Fri, 13 May 2016 14:29:21 GMT

Alternatively, enclose the Aggr() in another function that overrides the year selection.

Sum({<Year>} if(Aggr(......)))

Re: Chart is not ignoring selection

inescastelhano — Fri, 13 May 2016 14:32:49 GMT

Yes, but that's because nothing is selected.

Re: Chart is not ignoring selection

inescastelhano — Fri, 13 May 2016 14:35:09 GMT

Sorry, I don't get it. Could you please write the entire expression? Thank you!

Re: Chart is not ignoring selection

sunny_talwar — Fri, 13 May 2016 14:38:58 GMT

Try this:

If(Only({<Year>}Aggr(Rank(Max({<[Flag_doesnt_matter]={T}, Year>}Value))<=1,[Client],Year,[Unit])),

Sum({<[Flag_doesnt_matter]={T}, Year>}Value))

This will ignore any selections in Year field

Re: Chart is not ignoring selection

inescastelhano — Fri, 13 May 2016 14:40:25 GMT

It works! Great! Thank you so much (again)

Re: Chart is not ignoring selection

inescastelhano — Fri, 13 May 2016 14:42:48 GMT

Only for learning purposes, what's the difference between writing

If(Only({<Year>}Aggr(Rank(Max({<[Flag_doesnt_matter]={T}, Year>}Value))<=1,[Client],Year,[Unit])),

Sum({<[Flag_doesnt_matter]={T}, Year>}Value))

and

If(Only({<Year=>}Aggr(Rank(Max({<[Flag_doesnt_matter]={T}, Year>}Value))<=1,[Client],Year,[Unit])),

Sum({<[Flag_doesnt_matter]={T}, Year=>}Value))

Re: Chart is not ignoring selection

sunny_talwar — Fri, 13 May 2016 14:45:19 GMT

None whatsoever. Means the same thing

Re: Chart is not ignoring selection

inescastelhano — Fri, 13 May 2016 14:46:22 GMT

Thanks!

Re: Chart is not ignoring selection

swuehl — Fri, 13 May 2016 14:47:15 GMT

Always remember:

Use Aggregation Functions!

Set Analysis in the Aggr function

Re: Chart is not ignoring selection

sunny_talwar — Fri, 13 May 2016 14:47:26 GMT

No problem. I am glad I was able to help