topic Re: Restrict dimension value display in QlikView

Restrict dimension value display

Thu, 11 Jun 2015 09:47:43 GMT

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

Re: Restrict dimension value display

PrashantSangle — Thu, 11 Jun 2015 09:51:52 GMT

Hi,

try

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

Regards

Re: Restrict dimension value display

stigchel — Thu, 11 Jun 2015 09:52:27 GMT

The correct syntax is

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

Re: Restrict dimension value display

MayilVahanan — Thu, 11 Jun 2015 09:56:56 GMT

Try like this

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

Re: Restrict dimension value display

jonathandienst — Thu, 11 Jun 2015 09:56:58 GMT

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.

Re: Restrict dimension value display

Thu, 11 Jun 2015 10:05:15 GMT

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

Re: Restrict dimension value display

PrashantSangle — Thu, 11 Jun 2015 10:17:08 GMT

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

Re: Restrict dimension value display

Thu, 11 Jun 2015 10:54:50 GMT

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

Re: Restrict dimension value display

Thu, 11 Jun 2015 11:11:19 GMT

How i can do that?

I have to wrine in my load Script?

Re: Restrict dimension value display

PrashantSangle — Thu, 11 Jun 2015 11:15:29 GMT

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

Re: Restrict dimension value display

Thu, 11 Jun 2015 11:18:19 GMT

Hi,

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

and remember to select 'Suppress When Value Is Null' for that dimension

Re: Restrict dimension value display

Thu, 11 Jun 2015 11:18:22 GMT

So if i understand well in my script, i have to replace 'Nom' by 'if (wildmatch(BD, 'ML', 'KL', 'BL'), [Nom]) as New_Nom' or i have to load 'Nom' and write that?

Re: Restrict dimension value display

PrashantSangle — Thu, 11 Jun 2015 11:22:30 GMT

Hi,

Can you paste your scipt here.

I can modify for you.

Regards

Re: Restrict dimension value display

Thu, 11 Jun 2015 12:00:42 GMT

thx that work but i want to do directy in the script

Re: Restrict dimension value display

Thu, 11 Jun 2015 12:09:31 GMT

Hi Max, i'll like to but i can't, my company is in energy sector and i must keep all informations confidential.

But i did what you say and i'll work, but in fact the problem in my case is that in reallity the 'Nom' and 'BD' filed is not in the same files (excels table) but the two file that connected with 'Nom' field :

So to summarize, i have one table with 'Nom' and other fields and a another table with 'Nom' too and 'BD'

so when i did what you explain to me diectly in my load script i get a error because 'Nom' and 'BD' are not in the same file( Table)

Any suggestion ? Thanks