topic Re: Severals fields in listbox and sorting within piechart in QlikView

Severals fields in listbox and sorting within piechart

Fri, 12 Sep 2014 08:44:08 GMT

Heya,

I have a question. So i have a Excel sheet with different ID nummers. I import these as ID, ID as ID1 and ID, ID as ID2.

I have three sheets in Qlikview. In the first one i use ID1, in the second one i use ID2.

I the thrid one i would like to summarise ID1 and ID2. No problem for the different charts, But i want borh ID1 and ID2 in a listbox, is that possible?

Onther question regarding piechart.

Is it possible to sort the Piechart so the biggest nummer are next to each other. For example i have costs. I want to see the three biggest cost next to each others, so you can see that only three costs are combined more that 75% and that the other, lets go with, 70 cost are small.

Thanks in advance,
Regards,
Erik

Re: Severals fields in listbox and sorting within piechart

tresB — Fri, 12 Sep 2014 08:53:05 GMT

You can have values from different fields in one listbox(using synthetic dimension), but that would have limitation, it might not respond to selection. Hence if you are just planning to have it for the purpose of display, you can go ahead with synthetic dimension (valuelist()/valueloop()). Otherwise, better you think of script solution.

Re: Severals fields in listbox and sorting within piechart

pradnyat — Fri, 12 Sep 2014 08:57:13 GMT

Hi Eric,

Regarding Pie chart, as per my understanding 'Do u want to display the costs in some sorting order' ,Right?

In Sort you can directly use Y-value in descending.

It will display the biggest values next to each other.

Hope this is what you are expecting.

Re: Severals fields in listbox and sorting within piechart

Fri, 12 Sep 2014 09:04:03 GMT

Perfect, thank you!

Re: Severals fields in listbox and sorting within piechart

Fri, 12 Sep 2014 09:07:15 GMT

I was able to solve it, thanks