Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
biob_stein
Contributor

How to limit chart dimension by exact string value

Dear Community,

how can i limit a chart dimension by an exact value that is a string and not a value.

Example:

Dimension : Car_Brands

Values : BrandA, BrandB, BrandX

now i want to limit this dimension inside a chart to Car_Brands = 'BrandX'

I tried this with the setting on the right => Limit => Exact value => Expresion Editor using this expression :  Car_Brands = 'BrandX'

But its not working!

How can i achive that?

5 Replies

Re: How to limit chart dimension by exact string value

In the dimension tab press Edit and write:

If(Car_Brands = 'BrandX', Car_Brands, Null())

then check the box "suppress when value is null"

let me know ...

biob_stein
Contributor

Re: How to limit chart dimension by exact string value

Hi Allesandro,

this works, but its not a solution for the build in limitation function.

Better would be just to type in the exact value inside the limit input box.

This is it how it should be as Qlik Sense users are not professionals and should use as less as possible script functions.

It seems tha QlikSense allows only to limit numeric values, but especially dimensions have mostly string values.

arthur_dom
Contributor III

Re: How to limit chart dimension by exact string value

Hi paul... actually i think it's simple as Alessandro said... i just tried here and in Fixed number (mine is in portuguese ) , i only put the Dim2='a' and it works... , try putting the Inferior limitation.... Screen Shot 2015-06-11 at 19.19.43.png

mov
Esteemed Contributor III

Re: How to limit chart dimension by exact string value

For the most non-technical user - give them a filter Car_Brands.  What's wrong with the good old selections?

biob_stein
Contributor

Re: How to limit chart dimension by exact string value

Hi Arthur,

can you please attach your example as we could not reproduce your example.