topic Re: How to exclude a value in dimension's field in QlikView

How to exclude a value in dimension's field

Tue, 05 May 2015 10:48:24 GMT

Hi,

i want to exclude one value in the field i'm using as dimension could you please help me about that?

i want to display Motor without '28 inch' for example.

awhitfield — Tue, 05 May 2015 10:59:18 GMT

Hi abdallah,

one way is to replace the list box dimension with an expression e.g.

if(Motor <> '28 Inch', Motor)

Andy

jagan — Tue, 05 May 2015 11:07:23 GMT

Hi,

You can achieve this using Calculation Dimension like below

If(Motor <> '28 Inch', Motor)

If you are doing this in chart you can exclude this in Set analysis expression

=Sum({<Motor -= {'28 Inch'}>} Sales)

Hope this helps you.

Regards,

Jagan.

patroser — Tue, 05 May 2015 11:09:33 GMT

If you want to avoid both "28 Inch"'s you could transform the value within the conditional check.

if(lower(Motor) <> '28 inch', Motor)

in this case don't forget to write 28 inch in lower case

Patrick

Peter_Cammaert — Tue, 05 May 2015 11:20:46 GMT

Maybe it's better to add some applymap() translation to your script so that different spellings all map to the same Dimension value?

Peter_Cammaert — Tue, 05 May 2015 11:25:13 GMT

Or a simple ...CAPITALIZE(Motor) AS Motor, ... in your script may already do wonders...

buzzy996 — Tue, 05 May 2015 11:26:03 GMT

try this, use expression instituted of field in ur list box.