Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Comparing Date with variable in Set Analysis

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.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Comparing Date with variable in Set Analysis

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

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

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Comparing Date with variable in Set Analysis

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

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

View solution in original post

Highlighted
Contributor

Re: Comparing Date with variable in Set Analysis

Thanks

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