Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to hide Expression (Column) in the BarChart

WeekOneItemTwoItems3>= ItemsTotalOneItem %TwoItems %3>= Items %
4095.056.070.022143.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 total221
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 %
OneItemTwoItems3>= ItemsTotal
95.056.070.0221
I am working only Ver8.2 -I can't implement Set analysis here
Advance Thanks for your help
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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.

View solution in original post

2 Replies
Anonymous
Not applicable
Author

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.

Not applicable
Author

Thanks Michael -It is working correctly