topic Re: hide dimension in qlikview in QlikView

hide dimension in qlikview

Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 18 May 2016 12:52:24 GMT

In the dimension write (Edit dimension)

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

then check the box "Exclude null values"

Let me know

Wed, 18 May 2016 13:10:18 GMT

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 — Wed, 18 May 2016 13:14:20 GMT

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

Dimension:

Country

Expression:

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

Anil_Babu_Samineni — Wed, 18 May 2016 14:10:53 GMT

May be like this,

Updated : This is Similar to @Sunny T

Please go to Ctrl+E --> 217364

And PFA.