topic Re: Sort a chart dynamically by Weekday-Hour in QlikView

Sort a chart dynamically by Weekday-Hour

j_nlucas — Fri, 05 Sep 2014 15:57:58 GMT

Hello,

I am trying to sort dinamycally the chart below. The user must be able to select the weekday he wants to sort by. For example, if the user selects "Wed", the first value of the chart will be "Wed 01:00", then "Wed 09:00" and so forth (see chart).

I have asociated a numeric value for each value of the dimension and it can be sorted by that value with no problem, the problem now is to make it dynamic.

Any ideas?

Thank you.

Joaquin

Re: Sort a chart dynamically by Weekday-Hour

JonnyPoole — Fri, 05 Sep 2014 16:05:45 GMT

Not sure i understand 100% . If they select 'Wed' do you want to filter out 'Mon' and 'Tues' values but show Wed and everything after? I think your chart is already sorted in chronological / weekday order....

Re: Sort a chart dynamically by Weekday-Hour

j_nlucas — Fri, 05 Sep 2014 16:08:43 GMT

I want that if the user selects "Wed" on a listbox, the first value of the chart will be Wed 01:00 (the first hour for the day selected) and will go all the way to Sunday and then Monday, and then the last value will be Tuesday. It goes around the weekdays.

Re: Re: Sort a chart dynamically by Weekday-Hour

JonnyPoole — Fri, 05 Sep 2014 16:20:53 GMT

Cool !

See if this helps. Using a variable , Set analyis and a custom sort order on the chart.

Re: Sort a chart dynamically by Weekday-Hour

MarcoWedel — Fri, 05 Sep 2014 23:36:24 GMT

Hi,

one possible solution:

hope this helps

regards

Marco

Re: Sort a chart dynamically by Weekday-Hour

j_nlucas — Mon, 08 Sep 2014 09:43:59 GMT

Hi Marco,

Thank you so much for your clever and neat solution. It works perfectly on my application. It's great.

Well done!

Joaquin

Re: Sort a chart dynamically by Weekday-Hour

MarcoWedel — Mon, 08 Sep 2014 10:32:03 GMT

Hi Joaquin,

thank you, you're welcome.

regards

Marco