Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Expression looks correct .
Check with your data and date value.
Regards,
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
try below expression
=sum({<CstDate1 = {">=$(=$(vMaxDate_30)) <=$(=$(vMaxDate))"}>}LineValue)
Regards,
Include all the date fields that could be selected in the set analysis like:
=sum({<CstFiscalPeriod,CstFiscalYear,CstDate, CstDate1 = {">$(=$(vMaxDate_30)) <$(=$(vMaxDate))"}>}LineValue)
Hi, please try with :
sum({<CstDate1 = {">$(=AddMonths(Max(CstDate),-1)) <=$(Max(CstDate))"}>}LineValue)