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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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])