Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis

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.

1 Solution

Accepted Solutions
Not applicable

Set Analysis

Hi Peter,

Here you are a possible solution.

Best regards.

4 Replies
Not applicable

Set Analysis

Hi Peter,

Here you are a possible solution.

Best regards.

Not applicable

SV:Set Analysis

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


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


BR
Jakob

Not applicable

SV:Set Analysis

Thank you Jakob.

Not applicable

Set Analysis

Thank you Miguel

Community Browser