topic Re: Custom Sort Issue in QlikView

Custom Sort Issue

Fri, 08 Jan 2016 11:41:16 GMT

Hi all,

I have applied a custom sort to a bar chart based on a month indicator. At the same time I have tried to apply the rule that I don't want anyone to be able to filter for with the month indicator by adding the set statement {<Month_Indicator=>} to my calculation.

The weird thing is that if someone does click on anything in the Month_Indicator field, it moves that month to the beginning of the bar chart, which messes up the trend that I am trying to display. It does not filter for that Month, so the filter clause works.

The moment I disable the custom sort, it does not do that.

I have searched on the community for this type of error, but only come up with how to implement a custom sort.

has anyone come across this yet or have an idea on how to get around this?

Thank you for your assistance!

Lucille

Re: Custom Sort Issue

Gysbert_Wassenaar — Fri, 08 Jan 2016 17:55:44 GMT

Have you added that set modifier to your sort expression too? Perhaps you can post a small qlikview document that illustrates the problem.

Re: Custom Sort Issue

Mon, 11 Jan 2016 11:04:25 GMT

Hi,

Thank you for responding.. I have attached the QV model, I have just removed all of the unnecessary and tried to mask it a bit.

I haven't added the set modifier to the sort expression. You will see that I need to be able to jump between monthly, weekly and daily as well..

I am not that fast with this site, so I just need to figure out how to attach the model

Thanks,

Lucille

Re: Custom Sort Issue

Mon, 11 Jan 2016 11:56:37 GMT

I managed to attach the model to my original discussion...

Re: Custom Sort Issue

sunny_talwar — Mon, 11 Jan 2016 12:54:18 GMT

Try this as your sorting expression:

if(PeriodType= 'Monthly', Only({<Period>} Period),

if(PeriodType= 'Weekly', Only({<Period>} SubmissionYear&WeekIndicator),

if(PeriodType = 'Daily', Date(Only({<Period>} SubmissionDate),'YYYYMMDD'))))