topic Show Data only for weeks in Qliksense pivot table in App Development

Show Data only for weeks in Qliksense pivot table

Aspiring_Developer — Mon, 30 May 2022 08:37:05 GMT

Hello All,

I have below table :-

Dimension -LOB_trend | REPORT_DATE

Measure- sum({<Monday_flag={1}, Year_trend={'$(=Max(Year_trend))'}>}TREND_VOL)

Flag I created at the backend :-

Here we are showing weekly data and here the week is starting from Monday , so it is specifically showcasing numbers for Monday date in every week.

My query is that in the filter above "Report_Date" , I want to show the same dates like i am showcasing the pivot table. Right now , Report_Date is showing all the dates , but i want to show only opening weeks date i.e of every monday .

How can I achieve it in the filter ? Can anyone please help ?

Thanks in advance

Re: Show Data only for weeks in Qliksense pivot table

MayilVahanan — Mon, 30 May 2022 08:40:20 GMT

You can bring one more field in the script similar to Monday_flag for Monday_Date also. so you can use in the filter with that new field

Re: Show Data only for weeks in Qliksense pivot table

Aspiring_Developer — Mon, 30 May 2022 10:00:18 GMT

Hello ,

@MayilVahanan Not very clear, could you share some sample example of the script

Re: Show Data only for weeks in Qliksense pivot table

MayilVahanan — Mon, 30 May 2022 10:11:44 GMT

Try like below and use "REPORT_DATE_MON" in the filter Panel.

If(WeekDay(REPORT_DATE)='Mon' or Day(REPORT_DATE)=1, REPORT_DATE) as REPORT_DATE_MON