topic Expanding a Pivot chart in QlikView

Expanding a Pivot chart

Tue, 23 Dec 2014 12:20:06 GMT

Hello,

I need your help for manipulating a pivot chart.

My customer wants to expand a specific column which is unexpanded in pivot chart.

For example,

When I try to expand the value 'B' of the Area dimension in pivot chart. after selecting a value('A') of the Area dimension in list box, I can not expand the remaining values except the 'A' which was selected .

How can I expand the Area which is not selected in list box ?

Please refer to the attach files.

Regards,

WanKi,

Re: Expanding a Pivot chart

Tue, 23 Dec 2014 12:30:57 GMT

HI,

do you want to expand your a values when you click on a in list box

and want to expand only b values when you click on b in list box

and same for others too.

thanks

s shrivas

Re: Expanding a Pivot chart

consenit — Tue, 23 Dec 2014 12:39:48 GMT

Hi there.

I believe the pivot table behavior you describe is by design.

Not sure about the possibility to achieve this using macros, though.

Kind regards,

Ernesto

Re: Expanding a Pivot chart

Tue, 23 Dec 2014 12:44:13 GMT

Hi Wanki,

Check you dimensions and remove the commented "//=if(WORKDATE=vl_SelWorkDate, AREA)" from dimension, it will work.

Regards,

Sajeevan

Re: Expanding a Pivot chart

Tue, 23 Dec 2014 12:57:38 GMT

Sudhanshu,

Yes, I want to expand all values, when I click the '+' sign, regardless of the value selected in the list box.

Thank you,

WanKi,

Re: Expanding a Pivot chart

padmanabhan_ram — Tue, 23 Dec 2014 13:03:54 GMT

Hi Please see my attachment, it is getting expanded.

Is this you are looking for.

Thanks

Padmanabhan

Re: Expanding a Pivot chart

Tue, 23 Dec 2014 13:04:28 GMT

Ernesto,

I think so.

If there are no selection in list box, I can expand the all values.

So, I am looking for the way , even it is an alternative.

Thanks a lot,

WanKi,

Re: Expanding a Pivot chart

Tue, 23 Dec 2014 13:08:40 GMT

Sajeevan,

I got it, thank you.

But, Why do you know that it is to be affected from the comments ?

Thank you very much ,

WanKi,

Re: Expanding a Pivot chart

Tue, 23 Dec 2014 13:23:30 GMT

Yes, right !!

The problem is the comments in the dimension expression.

So I solved it.

Thank you,

WanKi,

Re: Expanding a Pivot chart

Tue, 23 Dec 2014 13:26:33 GMT

Hi Wanki,

I had a similar experience!

Thanks,

Sajeevan