Wild Card in set Expression with variable

[patricesalem]

Hello

I'm trying to combine the use of wild cards and variable in set expression for producing a chart & table (qlik sense sheet)

Here is what works  (use of " front of PROMOUP):

sum({<Year={'$(=$(vCurrentYear))'},[Hierarchie-hierarchie]-={'PIECE'},[cde_achat]={"*PROMOUP*"}>}qte_commandee)

If I replace PROMOUP by a variable (vPromo), the following works :

sum({<Year={'$(=$(vCurrentYear))'},[Hierarchie-hierarchie]-={'PIECE'},[cde_achat]={$(vPromo)}>}qte_commandee)

I don't manage to get it to work with vPromo and *

Any idea about the correct syntax ?

thanks

[sunny_talwar]

How is vPromo defined?

[patricesalem]

in the variable module

for test purpose, I have set it up as follow:

then the user will be able to change it using qsvariable :

[patricesalem]

I have just noticed that the following expression works

sum({<[cde_achat]={"*$(=$(vPromo))*"}>}net_commande)

only if the inputbox field is between quotes '  '

but I don't want the user to write ' '

[patricesalem · Accepted solution]

Bingo !

sum({<[cde_achat]= {"*$(=(vPromo))*"}>}net_commande),

only remove the $ front of the variable parenthesis

thanks for your support