Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to make a selection box for multiple fields (sales, quantity, sep) so that when one is selected (sales) all charts show (sales) data
Hi,
Use this as condition
=SubStringCount(Concat(UnitSelection, '|'), 'Sales') for sales exp
=SubStringCount(Concat(UnitSelection, '|'), 'SEP') for SEP exp
=SubStringCount(Concat(UnitSelection, '|'), 'Quantity') for Quantity exp
Celambarasan
can u elaborate, what u want against sales,quantity
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?
what u have in ur chart??
for example, one chart has the fields
Pharmacy
Sales
Quantity
SEP
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
Hi,
Which version of qlikview your using?
Celambarasan
Qlikview 11
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
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?