topic Set Analysis in QlikView

Set Analysis

Tue, 13 Jan 2015 16:36:25 GMT

Hi, i am having trouble getting the syntax right for set analysis if somebody could help please?

I want to return the expression =$(vPriMeasure_1_Value) but only where Dimension DIO is equal to Direct

Many Thanks

Re: Set Analysis

alexandros17 — Tue, 13 Jan 2015 16:39:50 GMT

There is something missing, the value to compute:

you can write

Sum({$ <myDimension={'DIO'}>} valueToCompute)

let me know

Re: Set Analysis

Tue, 13 Jan 2015 16:41:37 GMT

Hi Marc,

Try Using the below Expression;

Only({<DIO={'Direct'}>}vPriMeasure_1_Value)

You may modify the Aggregation as per your need.

Hope it helps.

Cheers !

Re: Set Analysis

reshmakala — Tue, 13 Jan 2015 16:44:33 GMT

Based on current selections, the expression can be

=Only({$<DIO={'Direct'}>}vPriMeasure_1_Value)

Re: Set Analysis

Tue, 13 Jan 2015 16:57:10 GMT

Ive tried all 3 of the solutions posted and non are working, it just returns a - in the column in the table. Do you because its using a variable?

Re: Set Analysis

alexandros17 — Tue, 13 Jan 2015 17:06:50 GMT

My solution is not using a variable, you cannot use it in a sum in that way, if Sum is the correct function, the question is what do you want to sum with the condition you have described?

Sum({$ <myDimension={'DIO'}>} valueToCompute)

Replace myDimension with your dimension and valueToCompute with the value you need to sum

Re: Set Analysis

jpapador — Tue, 13 Jan 2015 17:18:16 GMT

Depending on the definition of your variable you may need to use the $ expansion:

Only({$<DIO={'Direct'}>}$(vPriMeasure_1_Value))

Is the expression =$(vPriMeasure_1_Value) working without the set analysis?

Re: Set Analysis

Tue, 13 Jan 2015 17:28:02 GMT

unfortunately that doesnt work, and yes it does calculate correctly without set analysis

it seems the expression sum(CD2MAPD_COST) brings back the same value as =$(vPriMeasure_1_Value)

so ive tried Sum({$ <DIO={'Direct'}>} CD2MAPD_COST) and so far that seems to be working ok.

Thank you all for your help - much appreciated!