median (aggr (sum always sensitive to a selection

[Anonymous]

Hello,

I start with Qlikview, I try to do the median of data that I was previously to do, I built the following formula:

the median (which is my finess and for the last completed year) aggr data data (which are the sum of my values ​​by Finess) following the indicator set in dimension:

median ({<[Finess RTC] =, YEAR = {$ (= MAX (YEAR))}>} aggr (sum (DISTINCT {<[Finess RTC] =, YEAR = {$ (= MAX (YEAR))}> } [VALUES]), INDICATORS, [Finess RTC]))

The ascended value is the expected value, so the top no worries, my problem is related to the fact that I want to compare the value of an institution in relation to this median.

To do so, I had to put an object "selection list" to be able to select the establishment that I want to analyze.

And by clicking on the name of the establishment, my formula goes up median the value of the establishment.

I thought that my set analysis with "[Finess RTC] =," would prevent my median value from moving.

Do you have any idea how to fix this problem?

PS: Do not hesitate to tell me if there is something missing to better explain my problem, this is the first time I post a question ...

[sunny_talwar]

Is it possible that Max(Year) changes with selection in Finess RTC? May be try this

Median({<[Finess RTC], YEAR = {$(=Max({<[Finess RTC]>} YEAR))}>} Aggr(Sum (DISTINCT {<[Finess RTC], YEAR = {$(=Max({<[Finess RTC]>}YEAR))}>} [VALUES]), INDICATORS, [Finess RTC]))

[Anonymous]

Hi,

Thanks for help,

Unfortunately it doesn'y work. The formula no longer displays any value with this change.

I try the formula without " YEAR = {$ (= MAX (YEAR))" and it's always sensitive to Finess RTC selection.

[sunny_talwar]

Would you be able to share a sample to show the issue?

[Anonymous]

Hi,

I found the cause of my problem.

I did a set analysis with my Finess RTC but I also have a column in my database with the name of the institution in addition to the code Finess. So, I added in my set analysis "name=," and it's no longer sensitive to my selection.

Thanks youn Sunny, for your help.

Have a nice day

[sunny_talwar]

Superb