Date Range Issue in Set Analysis

[mhmmd_srf]

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]

Expression looks correct .

Check with your data and date value.

Regards,

[schlettig]

Hi Mohammad,

you could try it with an "AsOf" Calendar.

Here's a very good example:

https://community.qlik.com/docs/DOC-13536

Best regards,

Christian

[PrashantSangle]

try below expression

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

Regards,

[tresesco]

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

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

[sergio0592]

Hi, please try with :

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