Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

last 30 days

Hi All,

How to filter last 30 days sales using set analysts.

Thanks,

Krishna.

5 Replies
pradosh_thakur
Master II
Master II

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)

Learning never stops.
luismadriz
Specialist
Specialist

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
Specialist
Specialist

Hi Krishna,


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

Many thanks,

Luis

satheshreddy
Creator III
Creator III

Hi Krishna,

you can use  below exp

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

Regards

Sathish

Chori
Contributor
Contributor

Creo que todas las propuestas fallan si no hay registros en el último o últimos días. 
Es decir, toman 30 días a partir del último registro.  Lo que pide entiendo que es: 30 días para atrás desde hoy o ayer.