topic Re: Chart sorting in QlikView

Chart sorting

Tue, 15 Mar 2016 14:12:49 GMT

Hello,

I have a difficulty to sort a chart with a calculated dimension.

I have a calculated dimension which displays 'YEAR'&'/'&'WeekNr', and is not sorting in correct order. I've tried all the possibilities.

=year(Date)&'/'&week(Date)

Do you have any suggestions ?

See the attachment.

Thank you,

Claudiu

its_anandrjs — Tue, 15 Mar 2016 14:15:50 GMT

In the sort properties

write in Sort By box and deselect all also you can select Load Order -> Original.

=year(Date)&'/'&week(Date)

Regards

Anand

marcus_sommer — Tue, 15 Mar 2016 14:16:44 GMT

For this you need a dual-function, like:

dual(year(Date) & '/' & week(Date), year(Date) * 100 + week(Date))

whereby it would be better to use "native" period-fields created within a master-calendar instead of using calculated dimensions: How to use - Master-Calendar and Date-Values

- Marcus

alexandros17 — Tue, 15 Mar 2016 14:19:15 GMT

Try With:

YEAR & '/' &' Num(Week,'00')' & 'Nr'

Tue, 15 Mar 2016 14:20:10 GMT

Thank you very much Marcus ! It worked.