Restrict dimension value display

[#1]

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]

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 · Accepted solution]

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