topic How to limit chart dimension by exact string value in App Development

How to limit chart dimension by exact string value

Anonymous — Thu, 11 Jun 2015 08:35:24 GMT

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?

Re: How to limit chart dimension by exact string value

alexandros17 — Thu, 11 Jun 2015 08:43:47 GMT

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

Re: How to limit chart dimension by exact string value

Anonymous — Thu, 11 Jun 2015 09:04:19 GMT

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.

Re: How to limit chart dimension by exact string value

arthur_dom — Thu, 11 Jun 2015 22:20:11 GMT

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

Re: How to limit chart dimension by exact string value

Anonymous — Fri, 12 Jun 2015 02:43:38 GMT

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

Re: How to limit chart dimension by exact string value

Anonymous — Fri, 12 Jun 2015 07:41:44 GMT

Hi Arthur,

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