Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to limit dimension values in the striaght table


Hi,

     I have a column District with many dstrict Id's in it.How to use this clumn as a dimension in a straight table by limiting only some particular id's??

1 Solution

Accepted Solutions
maxgro
MVP
MVP

if you only want a b

dimension          =if( match(District, 'a','b'), District)

Check "suppress when value is null" flag in dimension tab

View solution in original post

3 Replies
datanibbler
Champion
Champion

Hi Tejaswini,

how do you know which IDs to limit the chart to? Is that information in some list? Is it dynamic?

You can use any IF_expression in the dimensions to use for your chart - but doing that takes away some choice from the user insofar as you pre-select the data for them. That might be okay depending on the wishes of your users, it just makes your chart less flexible than it could be.

Best regards,

DataNibbler

Anonymous
Not applicable
Author

Hi Tejaswini,

Use calculated dimension, like:

=if(district id=id's you need,District)

maxgro
MVP
MVP

if you only want a b

dimension          =if( match(District, 'a','b'), District)

Check "suppress when value is null" flag in dimension tab