topic Conditional Expression with selected fields in QlikView

Conditional Expression with selected fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear folks,

I am trying to calculate an expression. In the listbox Source I have 3 fields: LATAM, EMEA and All.

If I select both LATAM and EMEA, I need to calcule the expression with values from all.

I tried that but did not work:

=
If
(
Source = 'LATAM' and 'EMEA',

Sum ({<Source='All'>}[GM %])
,
Sum([GM %])
)

You guys can help me?

Thx

tresB — Thu, 20 Sep 2018 12:16:45 GMT

Try like:

=If(GetFieldSelections(Source)='EMEA, LATAM',Sum ({<Source='All'>}[GM %]),Sum([GM %]))

Anonymous — Thu, 20 Sep 2018 12:21:37 GMT

Thx for the fast response

This expression is returning the value 0.

tresB — Thu, 20 Sep 2018 12:22:44 GMT

Could you share your sample qvw to check?

Anonymous — Thu, 20 Sep 2018 13:19:12 GMT

No need.

That worked:

=
If(
GetFieldSelections(Source)='EMEA, LATAM'
,
-(Sum ([GM %]) - Sum({<[Source]=>}[GM %]))
,
Sum([GM %])
)

Thank you anyways