topic Re: Charts - change row for column in QlikView

Charts - change row for column

Mon, 19 Nov 2012 12:55:40 GMT

Hi,

please help - i have one Mekko chart and i don´t know how to change axis of both parameters - put periods to down axis and 1,2,3 to the right - i need the same function like a simmilar function "change row for column" in MS excel - description is in attachment

I have not found any function in charts options

Thx a lot:-)

Jaromir

Re: Charts - change row for column

Gysbert_Wassenaar — Mon, 19 Nov 2012 12:59:34 GMT

Change the order of the dimensions by promoting the second dimension (or demoting the first)

Re: Charts - change row for column

Mon, 19 Nov 2012 13:16:55 GMT

Hi,

thx for your answer,

but i have only one dimension and than only expressions,so i cannot change anything?!

Re: Charts - change row for column

Gysbert_Wassenaar — Mon, 19 Nov 2012 13:39:58 GMT

One expression? Are you sure you don't have three? Can you post the qvw you're working on?

Re: Charts - change row for column

Mon, 19 Nov 2012 13:51:28 GMT

Expressions three,but only one dimension

I could send you only images of properties - it´s in attachment

thx;-)

Re: Charts - change row for column

Gysbert_Wassenaar — Mon, 19 Nov 2012 14:00:14 GMT

I don't know if you have a year field. Your expression labels suggest you do. You could make year your dimension and change the expressions so the calculate the amounts per ex_Lokalita value instead of per year. That's the only option I'm afraid.

Re: Charts - change row for column

Mon, 19 Nov 2012 14:35:52 GMT

you´re right,it was neccesary to exchange both dimensions a do some other adjustments.

so thx a lot;-)

bye