Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Bingo !
sum({<[cde_achat]= {"*$(=(vPromo))*"}>}net_commande),
only remove the $ front of the variable parenthesis
thanks for your support
How is vPromo defined?
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 :
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 ' '
Bingo !
sum({<[cde_achat]= {"*$(=(vPromo))*"}>}net_commande),
only remove the $ front of the variable parenthesis
thanks for your support