Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
MVP
MVP

Master Calender missing Monday

What is wrong in Master Calendar from enclosed document?

1) When I tried InvoiceDate and WeekDay in TableBOX, everything is OK

2) When I tried the same with InvoiceDate as Dimension and WeekDay as Expression in Straight Table, end result missing all Mondays.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Master Calender missing Monday

Disable 'Suppress zero values' in presentation tab of straight table properties (Mon has a numerical representation of zero).

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Master Calender missing Monday

Disable 'Suppress zero values' in presentation tab of straight table properties (Mon has a numerical representation of zero).

View solution in original post

Highlighted
MVP
MVP

Re: Master Calender missing Monday

So Simple !!!

Highlighted
iktrayanov
Contributor III

Re: Master Calender missing Monday

There is nothing wrong with your calendar.

You have problem with SORT. The dates are there they are not sorted correctly.