topic SV:Set Analysis in QlikView

Set Analysis

Thu, 03 Dec 2009 19:11:27 GMT

example data:
Period 1 has Value 1500
Period 2 has Value 2500
Period 3 has Value 3500

the following expression:

sum({$<Period = {1,2} >} Value)

gives me the correct result of 4000 as it is selecting only Period = 1 and 2.

I want to be able to select only Period 3 and for this set analysis to give me the result aggregation Period 1, 2 and 3, i.e. 7500.

Therefore I want an expression to look at ALL Values where the Period is less than or equal (<=) to the current selection.

Thu, 03 Dec 2009 19:25:08 GMT

Hi Peter,

Here you are a possible solution.

Best regards.

Thu, 03 Dec 2009 19:41:03 GMT

Or instead of variables, you can use the following expression:


sum({$<Period = {"<=$(#=max(Period))"} >} Value)

BR
Jakob

Thu, 03 Dec 2009 20:30:47 GMT

Thank you Jakob.

Thu, 03 Dec 2009 20:31:10 GMT

Thank you Miguel