topic How to hide Expression (Column) in the BarChart in QlikView

How to hide Expression (Column) in the BarChart

Sat, 09 May 2009 02:20:04 GMT

Week	OneItem	TwoItems	3>= Items	Total	OneItem %	TwoItems %	3>= Items %
40	95.0	56.0	70.0	221	43.0%	25.3%	31.7%



If the counter has value 1 -finding how many line item has value 1
If the counter has value 2 -finding how many line item has value 2
If the counter has value 3 or greater than 3 values -finding how many line item has value 3 and morethan 3

Column(1)+Column(2)+column(3) - I am able to get the total					221

For reporting I need to display the %of each item per cal week
Straight table -Column(1)/Column(4) -I can find the % of One Item
OneItem %	TwoItems %	3>= Items %
43.0%	25.3%	31.7%


For the Bar chart - how can I hide the columns below and find the % and display the values as %

OneItem	TwoItems	3>= Items	Total
95.0	56.0	70.0	221


I am working only Ver8.2 -I can't implement Set analysis here


Advance Thanks for your help

How to hide Expression (Column) in the BarChart

Anonymous — Sat, 09 May 2009 02:40:53 GMT

First, you don't have to use the same exact expresions in the bar chart as you use in the staright table. You can use:
(number of line item has value 1) / (number ofline item has value 1 or more)
(number of line item has value 2) / (number ofline item has value 1 or more)
(number of line item has value 3 or more) / (number ofline item has value 1 or more)

Second, if for some reason you have to use the same expressions - try to check "Invisible" on the expression properties.

How to hide Expression (Column) in the BarChart

Mon, 11 May 2009 23:21:18 GMT

Thanks Michael -It is working correctly