Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hide dimension in qlikview

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.

1 Solution

Accepted Solutions
sunny_talwar

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

Dimension:

Country

Expression:

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

View solution in original post

4 Replies
alexandros17

In the dimension write (Edit dimension)

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

then check the box "Exclude null values"

Let me know

Not applicable
Author

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

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

Dimension:

Country

Expression:

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

View solution in original post

Anil_Babu_Samineni

May be like this,

Updated : This is Similar to @Sunny T

Please go to Ctrl+E --> 217364

And PFA.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)