Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

Show data for last 5 days in qlik

Hello Team,

 I have a below data and i need to show the data only for last 5 days , last 60 days in my pivot table .

Aspiring_Developer_0-1647246725618.pngAspiring_Developer_1-1647246771151.png

So here is my expected output, Dimension will be 'LOB' and measure is Count(issue_no) and measure 2 -sum(opendays).

So , the above measure should show the numbers for last 5 days on the basis of report_date. Can anyone please help ?

Thanks in advance.

Labels (1)
1 Reply
anat
Master
Master

Count( {< Date={">=$(=Date(max(Date)-5))"} >}[column A])