Issue with variable in set expression - Qlik sense

[QSMACHBI]

Hi ,

I need your help guys,

I have a variable named : vIsPreviousPeriode

When I use this variable in a set expression to feed a column in a table objet, I don't get the good result ! (all the time 0 value !!!)

1. First I calculate the vIsPreviousPeriode

2. I use this syntax : =SUM({$<Myfield = {$(=vIsPreviousPeriode)}>} Mymeasure)

[QSMACHBI]

I tried this syntax (=Sum({$<Myfield = {"$(=vIsPreviousPeriode)"}>} Mymeasure)) , before posting my issue !

It doesn't work ! 

[QSMACHBI]

[silvacarlos]

I don't know if you can set a variable with other 2 variables inside, I'll search information about that

[sunny_talwar]

How about this?

=Sum({$<Myfield = {"$(=$(vIsPreviousPeriode))"}>} Mymeasure)

[QSMACHBI]

It works fine with the last syntax.

Thank you very  much

[sunny_talwar]

Awesome!!! Please close the thread by marking correct and helpful responses.Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny