topic Bar Chart - Show all values - keep order in QlikView

Bar Chart - Show all values - keep order

prees959 — Tue, 12 Sep 2017 10:46:37 GMT

Hi,

I have a bar char which shows a dimension by day of the week:

I need to be able to show all values when one say is selected and also keep the sort order of Monday to Sunday is this possible rather than pushing the selected day to the end of the axis :

also - is there a way to hide the dimension with no value : '-' ??

Thanks,

Phil

Re: Bar Chart - Show all values - keep order

shraddha_g — Tue, 12 Sep 2017 10:48:10 GMT

Uncheck Show Null Value in Dimension Tab

Re: Bar Chart - Show all values - keep order

effinty2112 — Tue, 12 Sep 2017 11:01:19 GMT

Hi Phil,

If you expression is of the form

Count(Shift)

change it to

Count({$<Day=>}Shift)

Where Day is the day dimension on your x axis. Now the expression will ignore selections on that field. To get rid of the '-' in the dimension tab check the option to suppress When Value Is Null.

Good luck

Andrew

Re: Bar Chart - Show all values - keep order

tresB — Tue, 12 Sep 2017 11:08:00 GMT

Check attached sample.