topic Line charts resorting months on click in QlikView

Line charts resorting months on click

Wed, 26 Mar 2014 18:54:31 GMT

On a line chart I have, months (Apr, May, Jun, ...etc) is resorting when a month is clicked on (ex. Jan, Feb, Mar,.....Dec, Apr). I need the date to remain (Apr, May, Jun, .... etc).

Re: Line charts resorting months on click

manojkvrajan — Wed, 26 Mar 2014 19:02:01 GMT

Paul - Clear all check boxes and Check ONLY Text A -> Z as mentioned below and see if that works.

Re: Line charts resorting months on click

MarcoWedel — Wed, 26 Mar 2014 19:12:13 GMT

Hi Paul,

do not use "text" but "numeric" sorting if the months result from timestamps or dates and thus are numeric.

regards

Marco

Re: Line charts resorting months on click

Wed, 26 Mar 2014 19:14:12 GMT

In mine I have expression as Ascending with bPeriod in the box under the expression and Numeric value as Ascending. As in my note, bPeriod = (Apr,may, Jun, Jul, Aug, ....). This seems to make a difference.

Re: Line charts resorting months on click

Wed, 26 Mar 2014 19:22:23 GMT

load an inline table before your loading your calendar table as below

(give month names in the order you wanted.

load Monthinline

[

Month

Apr

May

Jun

................

];

you can delete this table once your calendar is loaded.

now in your chart use 'Load order = Original ' as your sorting

Re: Line charts resorting months on click

MarcoWedel — Wed, 26 Mar 2014 19:25:15 GMT

you are saying the sort order you expect is and remains "Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar" and is defined by your expression bPeriod?

Then if bPeriod changes, the sorting order of the Month dimension also changes.

You could check the sort-by-expression check box and use a static expression like

if(Month > 3, Month-3, Month+9)

instead (also unchecking every other check box and provided your Month field is indeed numeric)

This way you would stick to the order "Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar" regardless of any selections.

regards

Marco

Re: Line charts resorting months on click

jerem1234 — Wed, 26 Mar 2014 19:31:03 GMT

Try enclosing the expression you are sorting with by only and with ignoring selections like:

only({1}bPeriod)

Hope this helps!

Re: Line charts resorting months on click

Wed, 26 Mar 2014 19:45:12 GMT

This worked.

Thank you.

Re: Line charts resorting months on click

Wed, 26 Mar 2014 19:57:09 GMT

only({1}bPeriod) did work.