topic Re: Set Analysis - Dynamic Set Modifiers for each Row/ Dimension Value in QlikView

Set Analysis - Dynamic Set Modifiers for each Row/ Dimension Value

___dl — Sat, 16 Nov 2024 19:38:56 GMT

I need to do a calculation where each row or value of dimension depends on the value of another calculation.

Here is a simple example - I want to count each Dimension where Data >= Target.

Re: Set Analysis - Dynamic Set Modifiers for each Row/ Dimension Value

jaibau1993 — Tue, 19 Nov 2019 07:44:34 GMT

Hi!

I honestly don't understand your example but following the title of the post:

Set analysis is evaluated once per chart. This means that you can not build a "row-wise set analysis" expression. Said so, this kind of issues may be solved using an IF statement.

Regards,

Jaime.

Re: Set Analysis - Dynamic Set Modifiers for each Row/ Dimension Value

___dl — Tue, 19 Nov 2019 10:07:18 GMT

Just what I thought. I encountered this issue several times. Thank you for your response!