topic Re: Date Range Issue in Set Analysis in QlikView

Date Range Issue in Set Analysis

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

HI All,

I want to have Sales for Last 30 days based on Date Selection. But this is not showing any value.

I am using below expression:

=sum({<CstDate1 = {">$(=$(vMaxDate_30)) <$(=$(vMaxDate))"}>}LineValue)

I am attaching my sample App. Could you please check and help me.

Please check in Detail Tab.

Thanks,

Sarif

PrashantSangle — Wed, 19 Jul 2017 08:39:08 GMT

Expression looks correct .

Check with your data and date value.

Regards,

schlettig — Wed, 19 Jul 2017 08:39:08 GMT

Hi Mohammad,

you could try it with an "AsOf" Calendar.

Here's a very good example:

Best regards,

Christian

PrashantSangle — Wed, 19 Jul 2017 08:42:39 GMT

try below expression

=sum({<CstDate1 = {">=$(=$(vMaxDate_30)) <=$(=$(vMaxDate))"}>}LineValue)

Regards,

tresB — Wed, 19 Jul 2017 09:36:26 GMT

Include all the date fields that could be selected in the set analysis like:

=sum({<CstFiscalPeriod,CstFiscalYear,CstDate, CstDate1 = {">$(=$(vMaxDate_30)) <$(=$(vMaxDate))"}>}LineValue)

sergio0592 — Wed, 19 Jul 2017 09:43:32 GMT

Hi, please try with :

sum({<CstDate1 = {">$(=AddMonths(Max(CstDate),-1)) <=$(Max(CstDate))"}>}LineValue)