topic Set Analysis with two or more conditions in variable in QlikView

Set Analysis with two or more conditions in variable

test_it_1234 — Sat, 16 Nov 2024 18:46:17 GMT

Hello,

i need some help.

I have this formular:

=count(DISTINCT {<STATUS_PRODUKT={"$(v_switch_status_produkt)"}>}Vertragsnummer)

STATUS_PRODUKT can be 'aktiv' or 'in Bearbeitung'

Now i can set the variable v_switch_status_produkt to 'aktiv' or 'in Bearbeitung', this works fine.

How can i set the variable to the condition 'aktiv', 'in Bearbeitung'?

I have tryed this but it is not working.

v_switch_status_produkt=Chr(39)&'aktiv'&Chr(39)&Chr(44)&Chr(39)&'in Bearbeitung'&Chr(39)

But the output looks correct to me.('aktiv','in Bearbeitung')

test_it_1234 — Fri, 17 Apr 2020 09:42:16 GMT

i find the error by my self 🙂

change this to

=count(DISTINCT {<STATUS_PRODUKT={"$(v_switch_status_produkt)"}>}Vertragsnummer)

=count(DISTINCT {<STATUS_PRODUKT={$(v_switch_status_produkt)}>}Vertragsnummer)

tresB — Fri, 17 Apr 2020 09:43:43 GMT

Try removing double quotes, like:

=count(DISTINCT {<STATUS_PRODUKT={$(v_switch_status_produkt)}>}Vertragsnummer)

Since your variable evaluation would itself have single quotes, this should work.