topic Re: Restrict dimension value display in QlikView

Restrict dimension value display

Wed, 17 Jun 2015 13:42:18 GMT

Hi everybody,

today i repost my probleme that i didnt solve

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

Exemple : my complete table

the solution was make a calculated dimesnion in a new table with this syntaxe : if (wildmatch(BD, 'ML', 'KL', 'BL'), [Nom])

And its work great, but its a performance killer,

Somebedy Know i to do that directly in the script load? so that i load only want i want (may be in a new table)

i join the files on this post

Thanks

sinanozdemir — Wed, 17 Jun 2015 13:49:07 GMT

If You want to filter the data in the load script, then you can do it with "Where" in the load script.

LOAD

FROM/Resident

Where Wildmatch(BD, 'ML', 'KL', 'BL')

Hope this helps.

Kushal_Chawda — Wed, 17 Jun 2015 13:58:32 GMT

Create field in load script as

load *,

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

From Table

Now use Nom_new in the dimension of your chart