Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

last 30 days

Hi All,

How to filter last 30 days sales using set analysts.

Thanks,

Krishna.

5 Replies
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.
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

Specialist
Specialist

Hi Krishna,


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

Many thanks,

Luis

Creator III
Creator III

Hi Krishna,

you can use  below exp

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

Regards

Sathish

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.