Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Filter out a value of a dimension in a chart

Hi,

I have a chart where I am trying to restrict the dimension values displayed in the chart.  I want it to show all the values for the proj_type_code field except ESG Activities.

This works:

=If (proj_type_code = 'ESG Activities', proj_type_code)

But this does not work:

=If (proj_type_code -= 'ESG Activities', proj_type_code)

Any help would be greatly appreciated

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Filter out a value of a dimension in a chart

You used my expression as calculated dimension?

Have  you checked "suppress when value is NULL"?

View solution in original post

6 Replies
Highlighted
MVP
MVP

Filter out a value of a dimension in a chart

Hi

I think you mismatched the use of -= with a set expression.

Why not try

=If (proj_type_code <> 'ESG Activities', proj_type_code)

?

Regards,

Stefan

Highlighted
Not applicable

Filter out a value of a dimension in a chart

Please see the two attachements.  Image 1 is the chart before filtering on the dimension. Image2 is after applying the filter.  Its not displaying properly.

image1.png

image2.png

Highlighted
MVP
MVP

Filter out a value of a dimension in a chart

Suppress null values of the calculated dimension on the dimensions tab.

Highlighted
MVP
MVP

Filter out a value of a dimension in a chart

You used my expression as calculated dimension?

Have  you checked "suppress when value is NULL"?

View solution in original post

Highlighted
Not applicable

Filter out a value of a dimension in a chart

Yes.  In the meantime, I got it to work by adding the filter to my expression:

count({$<proj_mgr_name -={"Admin","*admin*"},proj_active_flag={"Yes"},proj_type_code -={"ESG Activities"}>}proj_nbr_id)

I'm just surprised that I can't seem to get this to work using a calculated dimension. 

Highlighted
Not applicable

Filter out a value of a dimension in a chart

I didn't check supress value when null.  Its working now - thanks.