topic Conditional expression based on different dimension attributes in QlikView

Conditional expression based on different dimension attributes

jduarte12 — Fri, 15 Nov 2024 23:48:27 GMT

Hi,

I have a table with the following information:

Dimension | Attribute | Value

A | 1 | x

B | 2 | 100

C | 2 | 200

D | 3 | 50

Where attribute and value are expressions. I need that for dimension with attribute=1, value being calculate upon the sum of values where attribute=2. In this case, x should be equal to 300.

I am trying with the following expression:

if(attribute=1, sum({1<attribute={2}>} value), sum(value))

However, I am getting x=0. I have not worked with Qlik for some time and I might be missing some very straightforward point. Can you please help?

Thanks in advance,

João

Re: Conditional expression based on different dimension attributes

MayilVahanan — Thu, 15 Oct 2020 08:13:31 GMT

Hi,

You can assign the value in the variable and use it in the expression like

vAttribute1 = Sum({1<Attribute={2}>} Value)

if(Attribute=1, $(vAttribute1), sum(Value))

Hope it helps

Output:

Re: Conditional expression based on different dimension attributes

jduarte12 — Thu, 15 Oct 2020 15:41:36 GMT

Thank you! It solved the problem.

Re: Conditional expression based on different dimension attributes

ElnurQV — Thu, 21 Sep 2023 10:53:12 GMT

Hi MayilVahanan,

I have similar question. I have the following table, where I would like the scenario A to take numbers from scenario B.

Scenario | Value

A | 0

B | 200

C | 250

D | 300

So as a result, scenario A would return 200.

I used your logic as a new expression but did not work. Rather scenario A remained 0 and scenario B remained 200.Might you have any idea how I may do that?