how to make a selection box for multiple fields (sales, quantity, sep) so that when one is selected (sales) all charts show (sales) data

[Anonymous]

how to make a selection box for multiple fields (sales, quantity, sep) so that when one is selected (sales) all charts show (sales) data

[#2]

can u elaborate, what u want against sales,quantity

[Anonymous]

I did a load inline to create a list box with the preexisting fields Sales, SEP, and Quantity.

when I select one of these fields in the listbox, I want the data in my charts to change to that selection.

So if I choose Sales, I want only sales data to appear.

Will my listbox be able to do that?

Is there a variable I need to use, like GetCurrent Field?

[#4]

what u have in ur chart??

[Anonymous]

for example, one chart has the fields

Pharmacy

Sales

Quantity

SEP

[#6]

kkk.. firstly create four varibles and assign them  a unique value..

now create four button of sales, parmacy etc,the go to the properties of button,then go action tab,click add button ,then go to External and choose set variable.after that give the varible name and its value.

After that go to sales chart ,click properties, go to layout,there there is conditional option...there u can put varible name with its value same as u have put in button...

hope fully this work for u

[CELAMBARASAN]

Hi,

     Which version of qlikview your using?

Celambarasan

[#8]

Qlikview 11

[CELAMBARASAN]

Hi,

     Then you can have a look at the Whats new in Qlikview 11 demo file under Reports sheet it is designed same as your requirements(dynamic dimension).

Celambarasan

[Anonymous]

Ican't use buttons, I need a listbox with the fields, or some other object that is similiar to a listbox in LED style

Not sure if it's relevant, but let me make a clarification. i'm using the fields

Sales

SEP

Quantity

as expressions in the charts.  Just a simple =sum()

I tried doing what they did under Reports in the QlikView 11 demo in one of my charts.  It hides Sales, SEP, and Quantity.

=SubStringCount(Concat(UnitSelection, '|'), 3)

Can I use this same expression or something similar in my listbox?

What do I have to do about the value in the expression, since I can only write one expression into the listbox?