topic Static line - set analysis in QlikView

Static line - set analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a line chart for monthly data from Dec-15,Jan-16,Feb-16,......Sep-16.

When I select any SalesDate value , my graph should not be changed the order from Dec,Jan,Feb,Mar,.....Sep.

Please advise.

Thanks in advance.

MK_QSL — Wed, 26 Oct 2016 08:24:20 GMT

Go to Sort Tab

Untick Sort By Expression (Date)

Tick Numeric Value

Wed, 26 Oct 2016 08:50:08 GMT

Thank You mrkachhiaimp.

If I do same, Dec going to last value. I want it first value in the sequence.

trdandamudi — Wed, 26 Oct 2016 08:58:19 GMT

See if the attached works for you...

MK_QSL — Wed, 26 Oct 2016 08:59:01 GMT

Sort by Expression

Only({1}Match(Month,'Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov'))

jagan — Wed, 26 Oct 2016 09:00:05 GMT

Hi,

You can use MonthYear as dimension, if you just display Month alone it will be confusing for users.

Hope this helps you.

Regards,

Jagan.

jagan — Wed, 26 Oct 2016 09:05:34 GMT

Hi,

Remove the Sort Expression and try.

Regards,

Jagan.