Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
16072416
Contributor
Contributor

Set analysis by dimention

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:

Example.png

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

Result.png

I use the set analysis:

set analysis.png

The data used is:

Data.png

How can I solve this?

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Try this in your expr:

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

Capture.PNG

View solution in original post

5 Replies
nsetty
Partner - Creator II
Partner - Creator II

Hi John

You have to use Generic Load to achieve the results.

Thanks

Nagesh

vishsaggi
Champion III
Champion III

Try this in your expr:

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

Capture.PNG

16072416
Contributor
Contributor
Author

Thanks for your answer

16072416
Contributor
Contributor
Author

Thanks for your answer. It will work correctly

vishsaggi
Champion III
Champion III

No Problem.