Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expanding a Pivot chart

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,

1 Solution

Accepted Solutions
Not applicable
Author

Hi Wanki,

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

Regards,

Sajeevan

View solution in original post

9 Replies
Not applicable
Author

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

consenit
Partner - Creator II
Partner - Creator II

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

Not applicable
Author

Hi Wanki,

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

Regards,

Sajeevan

Not applicable
Author

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,

padmanabhan_ram
Creator II
Creator II

Hi Please see my attachment, it is getting expanded.

Is this you are looking for.

Thanks

Expand.pngPadmanabhan

Not applicable
Author

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,

Not applicable
Author

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,



Not applicable
Author

Yes,  right !!

The problem is the comments in the dimension expression.

So I solved it.

Thank you,

WanKi,

Not applicable
Author

Hi Wanki,

I had a similar experience!

Thanks,

Sajeevan