Exclude a specific key from a dimension of Bar Chart

[#1]

I would like to Exclude a specific key ('All') from a dimension of Bar Chart but to preserve it into the pivot table.

I attached the qlikview file here.

[prabiradhikary]

use this expression in bar chart.

Sum({<[Product Type]=E({<[Product Type]={'All'}>} [Product Type])>}[Total VaR once Removed])

[Gysbert_Wassenaar]

Change your bar chart expressions to include a filter. For example change sum([Marginal 1%]) into sum({<Currency-={'TWD'}>}[Marginal 1%])

[sunny_talwar · Accepted solution]

Do you want to see TWD or All? If you want to see TWD, then use Currency as your dimension (instead of product type) and use these expressions:

Sum({<Currency -= {'All'}>} [Marginal 1%])

Sum({<Currency -= {'All'}>}[Marginal 10%])

Sum({<Currency -= {'All'}>}Marginal)

Sum({<Currency -= {'All'}>}[Individual VaR])

Sum({<Currency -= {'All'}>}[Total VaR once Removed])