topic Re: Charts and Grouping orders in QlikView

Charts and Grouping orders

knightwriter — Wed, 01 Jul 2015 14:46:59 GMT

Hi All,

I have a chart and two groups options attached.

Is it possible to have option A sort by value and option B sort by month?

As per my screenshot below, you can see that the month (option B) is being sorted by value from option A.

Many thanks.

Re: Charts and Grouping orders

stigchel — Wed, 01 Jul 2015 14:51:12 GMT

You can use the sort by expression option, something like

If(GetCurrentField(Group)='Month',Num(Month), YourExpressionforValue)

Re: Charts and Grouping orders

knightwriter — Wed, 01 Jul 2015 15:12:46 GMT

Hi Piet,

Thanks for the note but unfortunately this does not work. Any other suggestions?

Re: Charts and Grouping orders

Anonymous — Wed, 01 Jul 2015 15:16:48 GMT

you can defne your sortorder in the Group definition

goto your group

select edit

right bottom you can define your sortorder for each Group member

that should work!

Re: Charts and Grouping orders

Wed, 01 Jul 2015 15:19:26 GMT

Possibly if you define each separately using alternate states. You can define an alternate state in document settings --> General --> and in the middle you will see Alternate States... Define an alternate states, for example OpA, which you will then use within you chart properties etc. as the object ID

Re: Charts and Grouping orders

pratap6699 — Wed, 01 Jul 2015 15:29:43 GMT

=sum(sales) is expression CyclicGroup is dimension

here we go to sort-->give expression =sum(sales) it display desending order quantity wise