Restrict dimension value display

[#1]

Hi everybody,

today i have a new problem with qlikview,

Problem :  i want to show the dimensions of my straight table only if that respect a condition

Exemple : my complete table

And what i want :

My solution was to write in the dimension 'Nom': if (BD= 'ML', 'KL', 'BL', [Nom]) , but this doesnt work , i also tried to replace "," by "+" and "or"

if (BD= 'ML'or 'KL',or 'BL', [Nom]) i get nothing with that.

If somebedy got a solution i'll appreciate that, Thanks you

[PrashantSangle]

Hi,

try

if (wildmatch(BD, 'ML', 'KL', 'BL'), [Nom])

Regards

[stigchel]

The correct syntax is

if(BD='ML' or BD='KL' or BD='BL', [Nom])

[MayilVahanan]

Hi

Try like this

=if (match(BD, 'ML', 'KL', 'BL'), [Nom])

[jonathandienst]

Rather keep the expression as a simple Nom, and filter the expression(s), something like

Sum({<BD = {'ML', 'KL', 'BL'}>} Sales)

I would reserve calculated dimensions only for those cases where the dimension has to be calculated on the fly as they can be performance killers.

[#6]

Thanks Max Dreamer  your syntax work perfectly, but as mentionned below Jonathan that kill performance because i havn't just 3 conditions like my example 'ML', 'KL', 'BL' but 15.

I'll try other option, but thx u very much

[PrashantSangle]

Hi,

Yes calculated dimension always performance killer,

So you can write same thing in Script and create new field and use that field as you dimension.

Which is much better option.

Regards

[#8]

Hi Jonathan can you explan more please,

like u said i doesent want to kill the performance but i'm new in qlik and your solution seems really good, can you explin me step by step please??

thanks you

[#9]

How i can do that?

I have to wrine in my load Script?

[PrashantSangle]

Yes

Where is your Nom Field

in next line write

that if (wildmatch(BD, 'ML', 'KL', 'BL'), [Nom]) as New_Nom

and use New_Nom as your dimension in chart.

Regards