topic Re: show if (front end) in QlikView

show if (front end)

Fri, 13 Jan 2012 18:27:58 GMT

Dears,

can you help with the following problem..

Preferably I would like to solve it in the front end.

Please open the attachment for better understanding.

In the top table I have fields: Captions, Reporting ORUs and the Key field (which consists of Caption+ReportingORU - was used for joining data btw. two source files).

Now, one ReportingORU per one caption can have several values in column 'Scope'. I ranked the values in Scope 1- Significant, 2-Non-significant, 3- Not in Scope (field 'Rank').

What I would like the lower straight table to do is to show per Reporting Org only Scope which relates to lowest Rank.

So in the example in the attachment it should look:

Captions ReportingORU Scope Min(Rank)

Accounts p. 128543, 166564..... Non-significant 2

Many thanks for help

Re: show if (front end)

Miguel_Angel_Baeyens — Fri, 13 Jan 2012 23:42:50 GMT

Hi,

I've recently answered a couple of questions in this regard (some additional info in this post among others). I'm quite sure those will work for you as well, and that should work assuming that Captions, ReportingORU and Scope are dimensions and something like this is the expression

FirstSortedValue(Scope, Rank)

Hope that helps.

Miguel

show if (front end)

Tue, 17 Jan 2012 15:43:25 GMT

I managed to find the solution also and used sum(aggr(min(Rank),Captions, ReportingORUs)) and also worked fine. Thanks a lot for help!