topic Comparing Date with variable in Set Analysis in QlikView

Comparing Date with variable in Set Analysis

supriyabiware — Tue, 25 Sep 2018 10:56:50 GMT

Hello All,

I have to write a conditional count in set analysis (if condition works but is very slow)

I tried 3 options -

1. count ({$ <Monat_Jahr={"=$(=Date(LADEDATUM,'MM/YY'))"},FARBE={2}>} distinct Supplier)

2. count ({$ <Monat_Jahr={'=(vLADEDATUM)'},FARBE={2}>} distinct Supplier)

3.count ({$ <Monat_Jahr={'09/18'},FARBE={2}>} distinct Supplier)

only 3rd one seems to work correct (which i have given manually) , other two seems to work but with wrong results.

Anyone knows what possibly is going wrong?

Thanks,

Supriya.

Anonymous — Tue, 25 Sep 2018 11:01:15 GMT

try second expression with (vLADEDATUM should be value in MM/YY

count ({$ <Monat_Jahr={'$(=vLADEDATUM)'},FARBE={2}>} distinct Supplier)

supriyabiware — Tue, 25 Sep 2018 11:05:14 GMT

Thanks

Seems i used $ once but inside with variable and dint try this way!