Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Custom Sort not working in a Pivot table & in Bar chart

Hi,

We have a field 'Day Abbreviation' with values as - Mon,Tue,Wed,Thu,Fri,Sat,Sun which is been used as a dimension in a

Pivot table and in a Bar chart.

Custom sort is done using Match(Day Abbreviation,'Mon','Tue','Wed','Thu','Fri','Sat','Sun').The selections are done based on Customer names,Year(2014)and Quarter(Q2).

Custom sort is working fine based on the above selections but when a selection is changed on Quarter for eg; from Q2 to Q3,Custom sort is not working for some of the Customer names.

Have tried using Inline table for sorting,dual() function and enabling  Load order on the 'Day Abbreviation' field,but couldn't resolve the sort issue.

Please suggest.

Thanks,

Neha

1 Solution

Accepted Solutions
MVP
MVP

Re: Custom Sort not working in a Pivot table & in Bar chart

Hi

I would try

     =Max({1} Match([Day Abbreviation], 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun'))

This will ignore any selections.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies

Re: Custom Sort not working in a Pivot table & in Bar chart

Hi,

If possible can share your sample apps.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
MVP
MVP

Re: Custom Sort not working in a Pivot table & in Bar chart

Hi

I would try

     =Max({1} Match([Day Abbreviation], 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun'))

This will ignore any selections.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser