Show data for last 5 days in qlik

Aspiring_Developer — Mon, 14 Mar 2022 08:35:51 GMT

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 .

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.

Re: Show data for last 5 days in qlik

anat — Mon, 14 Mar 2022 11:51:30 GMT

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