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:
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:

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?

1 Solution

Accepted Solutions
Champion III

Try this in your expr:

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

5 Replies
Partner - Creator II

Hi John

You have to use Generic Load to achieve the results.

Thanks

Nagesh

Champion III

Try this in your expr:

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

Contributor
Author

Thanks for your answer

Contributor
Author

Thanks for your answer. It will work correctly

Champion III

No Problem.

Community Browser