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

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 — Thu, 12 Apr 2012 06:56:21 GMT

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

Thu, 12 Apr 2012 07:12:58 GMT

can u elaborate, what u want against sales,quantity

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 — Thu, 12 Apr 2012 07:18:37 GMT

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?

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

Thu, 12 Apr 2012 07:20:56 GMT

what u have in ur chart??

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 — Thu, 12 Apr 2012 07:25:05 GMT

for example, one chart has the fields

Pharmacy

Sales

Quantity

SEP

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

Thu, 12 Apr 2012 07:46:29 GMT

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

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

CELAMBARASAN — Thu, 12 Apr 2012 08:47:56 GMT

Hi,

Which version of qlikview your using?

Celambarasan

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

Thu, 12 Apr 2012 08:57:16 GMT

Qlikview 11

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

CELAMBARASAN — Thu, 12 Apr 2012 09:04:15 GMT

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

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 — Thu, 12 Apr 2012 10:13:28 GMT

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?

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

CELAMBARASAN — Thu, 12 Apr 2012 10:23:08 GMT

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

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 — Thu, 12 Apr 2012 10:50:11 GMT

awesome, works perfect for my straight tables

shows all the data, Sales, SEP and Quantity when none of those are selected in my UnitSelection listbox. and Just what is selected when a selection is made.

Can you help with my bar charts as well?

I want to do the same thing, but I don't want all the data to show when nothing is selected. Is there a way to hide Quantity and Sales?

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

CELAMBARASAN — Thu, 12 Apr 2012 11:42:20 GMT

Hi,

Use getFieldSelections instead of Concat

=SubStringCount(GetFieldSelections(UnitSelection, '|',10), 'Sales')

=SubStringCount(GetFieldSelections(UnitSelection, '|',10), 'Quantity')

Celambarasan