topic Re: Set analysis by dimention in QlikView

Set analysis by dimention

Anonymous — Fri, 07 Sep 2018 21:07:57 GMT

Hello,

I want to Calculate a set analysis that depend on the dimention, I have dimentions Indicator and Train, and we want to calculate the value by Indicator and Train for the max Year(the max year of each train).

I need something like this:

but I get (it only calculates the value for the max year, but I need the value for the max year per train):

I use the set analysis:

The data used is:

How can I solve this?

Re: Set analysis by dimention

nsetty — Fri, 07 Sep 2018 22:17:26 GMT

Hi John

You have to use Generic Load to achieve the results.

Thanks

Nagesh

Re: Set analysis by dimention

vishsaggi — Sat, 08 Sep 2018 04:08:39 GMT

Try this in your expr:

= Firstsortedvalue(Value, -Aggr(Max(Year), Indicator, Train))

Re: Set analysis by dimention

Anonymous — Thu, 11 Oct 2018 13:18:11 GMT

Thanks for your answer

Re: Set analysis by dimention

Anonymous — Thu, 11 Oct 2018 13:19:32 GMT

Thanks for your answer. It will work correctly

Re: Set analysis by dimention

vishsaggi — Thu, 11 Oct 2018 16:35:31 GMT

No Problem.