How to limit chart dimension by exact string value

[Anonymous]

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?

[alexandros17]

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 ...

[Anonymous]

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]

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....

[Anonymous]

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

[Anonymous]

Hi Arthur,

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