topic Re: Set Analysis with Variables in QlikView

Set Analysis with Variables

breno_morais — Thu, 06 Sep 2018 14:22:24 GMT

Dear All,

I'm using a variable for take filter and use in my set analysis, but don't works. Any help?

vCor = GetFieldSelections(COR_RACA)

KPI = Count ( {$<COR_RACA= {"=$(vCor)"}>} UNIC_ID)

Why this doesn't works? If I do not use the variabel it's better

vishsaggi — Thu, 06 Sep 2018 14:35:32 GMT

Try this?

KPI = Count ( {$<COR_RACA= {"$(=$(vCor))"}>} UNIC_ID)

OR just

KPI = Count ( {$<COR_RACA= {$(vCor)}>} UNIC_ID)

stigchel — Thu, 06 Sep 2018 14:56:17 GMT

If you want to handle multiple field selections as well, you need to include the delimiters. Try like

For vCor (include the = sign)

=Concat(DISTINCT COR_RACA,Chr(39)&','&Chr(39))

KPI

=Count({<COR_RACA={'$(vCor)'}>} UNIC_ID)