Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

ignore incomplete week from source Qlik sense.

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!!!

 

Labels (4)
3 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

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

Jordy

Climber

Work smarter, not harder
UserID2626
Partner - Creator III
Partner - Creator III
Author

how to stop the calendar   ,

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

 

JordyWegman
Partner - Master
Partner - Master

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

Jordy

Climber

Work smarter, not harder