Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bartvanwetten
Contributor

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!

Tags (3)
1 Solution

Accepted Solutions

Re: Sortorder (weekday+date) in pivottable

May be this sort order in the cycle group itself

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

2 Replies

Re: Sortorder (weekday+date) in pivottable

May be this sort order in the cycle group itself

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

bartvanwetten
Contributor

Re: Sortorder (weekday+date) in pivottable

And again works fine!