topic Re: Wild Card in set Expression with variable in QlikView

Wild Card in set Expression with variable

patricesalem — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 25 Oct 2018 11:46:07 GMT

How is vPromo defined?

patricesalem — Thu, 25 Oct 2018 11:49:55 GMT

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 — Thu, 25 Oct 2018 11:59:35 GMT

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 — Thu, 25 Oct 2018 12:12:12 GMT

Bingo !

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

only remove the $ front of the variable parenthesis

thanks for your support