topic Re. :bar chart selection in QlikView

bar chart selection

Mon, 18 Apr 2011 12:48:24 GMT

Hi,

Assume I have this table:

Date	Time	Device_Name	Value
13/03/2011	00 :00 :00	Device A	111
13/03/2011	01 :00 :00	Device A	222
13/03/2011	02 :00 :00	Device A	333
13/03/2011	03 :00 :00	Device A	444
13/03/2011	00 :00 :00	Device B	555
13/03/2011	01 :00 :00	Device B	666
13/03/2011	02 :00 :00	Device B	777
13/03/2011	03 :00 :00	Device B	888
13/03/2011	00 :00 :00	Device C	999
13/03/2011	01 :00 :00	Device C	1000
13/03/2011	02 :00 :00	Device C	1001
13/03/2011	03 :00 :00	Device C	1002
13/03/2011	00 :00 :00	Device D	1100
13/03/2011	01 :00 :00	Device D	1200
13/03/2011	02 :00 :00	Device D	1300
13/03/2011	03 :00 :00	Device D	1400

I have also a list box with "Device_Name" dimension.

I would like to display 1 bar chart if the user select 1 device, 2 bar charts if the user select 2 devices and 3 bar charts if the user select 3 devices no more (Value as dimension)

Do you have any ideas ?

Thank you

Re. :bar chart selection

vincent_ardiet — Mon, 18 Apr 2011 13:11:10 GMT

Hi Jeremy,

If you make a bar chart with Device_Name in dimension and Value as a measure, it while work.

And if you don't want to display more than 3 devices, check in Presentation tab the 'Max visible Number' option and set it to 3.

If user select 4 values, it will only see 3 of them (the sort order will determine which of them will be displayed).

Regards,

Vincent

Re. :bar chart selection

Mon, 18 Apr 2011 13:33:21 GMT

So I made a bar chart with 2 dimensions (Device_Name and Time), as expression (Value) and limitations as you said it works pretty well !

Thank you for your help Vincent