topic Re: Date in set analysis doesn't work in QlikView

Date in set analysis doesn't work

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

I can't seem figure out why below expression doesn't work?

Sum({<CUSTOMER -= {'IA','KA','BA'},EFlag = {1}, TILLÆG = {0}, Promostep = {0}, Enet = {100,149,299}, Created = {">=$('05-05-2017')"} >} Enet_calc)

It seems like the expression simply ignore the date limitations, and just present the full value, as if the date limitation wasn't implemented.

Below is the dimension I'm trying to use.

I guess it might be something with date format or something. But I tried several alternatives found on the internet, and nothing seems to fix it.

I hope someone can help.

Regards

Stefam

Re: Date in set analysis doesn't work

lironbaram — Tue, 08 Aug 2017 09:45:53 GMT

maybe something like this

Sum({<CUSTOMER -= {'IA','KA','BA'},EFlag = {1}, TILLÆG = {0}, Promostep = {0}, Enet = {100,149,299}, Created = {">=$(=date('05-05-2017','dd-MM-yyyy'))"} >} Enet_calc)

Re: Date in set analysis doesn't work

swuehl — Tue, 08 Aug 2017 09:48:08 GMT

Why are you using a dollar sign expansion on a constant value?

Try

Created = {">='05-05-2017'"}

If DD-MM-YYYY is your default date format.

Or maybe

Created = {">=42860"}

Re: Date in set analysis doesn't work

Anonymous — Tue, 08 Aug 2017 09:51:01 GMT

This worked.

However, I've tried this before. Maybe I've forgotten parentheses or something.

But thanks so much for the quick respons!

Regards

Stefan