ignore incomplete week from source Qlik sense.

[UserID2626]

Hi,

i have a requirement to show weekly which is daily report.

Consider having data from 10-Oct-2018 to 28-May-2019, I have to show last 3 weeks data where Max week is 22 (26-May-2019 to 01-June-2019) which is not yet completed.

I used below set expression;

sum({<[Date]=,[Week]=,[Month]=,[Date]={"<=$(=Weekend(max([Date])))>=$(=Weekstart(Max([Date])-19))"}>}Revenue)

This set expression works as below

Week 22 : 26-May-2019 to 01-June-2019

Week 21 : 19-May-2019 to 25-May-2019

Week 20 : 12-May-2019 to 18-May-2019

By default Week 22 should be ignored and wants to see result from week 21 to week 19.

Selection of date/Week/month/year should change accordingly(i.e, selecting week 22 in filter pane should display result for 26-May-2019 to 28-May-2019).

Thanks in advance!!!

[JordyWegman]

Hi,

What you can do is stop the calendar after 28-05-2019. Then the last dates won't show.

Jordy

Climber

[UserID2626]

how to stop the calendar  JordyWegman ,

if i clear auto generated section, i cannot see data in data manager section.

[JordyWegman]

Can you show an image of your data model viewer? Then I can see what the solution needs to be.

Jordy

Climber