Show Data only for weeks in Qliksense pivot table

[Aspiring_Developer]

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

[MayilVahanan]

HI

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

[Aspiring_Developer]

Hello ,

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

[MayilVahanan · Accepted solution]

Hi 

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