Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

krishna4bo
Contributor

last 30 days

Hi All,

How to filter last 30 days sales using set analysts.

Thanks,

Krishna.

Tags (1)
4 Replies
pradosh_thakur
Valued Contributor III

Re: last 30 days

something like

please check your date format and apply accordingly

sum({<datefiled={"=datefield>=max(datefield)-30"}>}sales)

or

sum({<datefiled={">=$(=max(datefield)-30)<=$(=max(datefield))"}>}sales)

luismadriz
Valued Contributor

Re: last 30 days

As Pradosh says, just change max(datefield)-30 to date(max(datefield)-30). If you need to, force the date format to suit, for example  date(max(datefield)-30,'M/D/YYYY')


I hope this helps,


Regards,


Luis

luismadriz
Valued Contributor

Re: last 30 days

Hi Krishna,


Please remember to close the thread by marking the correct and helpful replies,

Many thanks,

Luis

satheshreddy
Contributor III

Re: last 30 days

Hi Krishna,

you can use  below exp

count({<Date={=date(Max(Date)-30,'DD-MM-YYYY')}>}id)

Regards

Sathish

Community Browser