Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Weekstart and multiple years in Combo Chart problem when comparing weeks

Hi all,

I have a problem in the presentation of the data in a combochart.

The combochart looks like this:

current year data in bars

previous year in a line

the data is grouped per week (weeknumber)

Eveyrthing looks fine, except that when I use this formula in the dimension tab

=dual(WeekStart([Date]), Week(Date))

It shows the first Monday of every week of the previous year.

I would like to see the first Monday of every week of the CURRENT year.

I've attached the (sample) application.

Best regards,

Arjan

Labels (1)
0 Replies