hide dimension in qlikview

[#1]

I have created a chart and wanted to hide a dimension/bar from that chart, how can I update that?

Country     Value

A     2000

B     3000

C     4000

D     5000

I do not want to show value C in my bar chart.

[alexandros17]

In the dimension write (Edit dimension)

if(Country='C', Null(), Country)

then check the box "Exclude null values"

Let me know

[#3]

In addition to Alessandro'point, we can write below script to hide multiple values in a dimension.

IF(not Match(Country,'A','C'),Country)

[sunny_talwar · Accepted solution]

I would prefer doing this using the set analysis as it offers better performance

Dimension:

Country

Expression:

Sum({<Country -= {'C'}>}Value)

[Anil_Babu_Samineni]

May be like this,

Updated : This is Similar to @Sunny T

Please go to Ctrl+E --> 217364

And PFA.