Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
bartvanwetten
Creator
Creator

Sortorder (weekday+date) in pivottable

Hi all,

In attached qvw is a pivottable with a dimension 'WeekDay+Date' horizontal. But somehow i cannot get the order right.

Can anybody help me out on this one?

Thank you in advance!

1 Solution

Accepted Solutions
sunny_talwar

May be this sort order in the cycle group itself

=RangeSum((Dim * 1E10), Date#(SubField(WeekDayName, ' ', -1), 'D-M-YYYY'))

View solution in original post

2 Replies
sunny_talwar

May be this sort order in the cycle group itself

=RangeSum((Dim * 1E10), Date#(SubField(WeekDayName, ' ', -1), 'D-M-YYYY'))

View solution in original post

bartvanwetten
Creator
Creator
Author

And again works fine!