make fied = field in Set Analysis

[Mahmoud]

hello, i'm new in qlikview, i have this expression:

Sum({<Mouvement_ID={$(vShowMouvement)},Année, Trimestre, Mois, Jour, Date, MoisAnnée, _ 
MonthDiff={"<12"}, MoisAnnéeTM={">=$(vDateMin12)<=$(vDateMax12)"}, _ID={'100'}
>} Total_Net_HT)

it's ok, but when i want to change _ID to this:

Sum({<Mouvement_ID={$(vShowMouvement)},Année, Trimestre, Mois, Jour, Date, MoisAnnée, _NIVEAU_GROUPE={'99'},
MonthDiff={"<12"}, MoisAnnéeTM={">=$(vDateMin12)<=$(vDateMax12)"}, _ID={_MAG_ID}
>} Total_Net_HT)

i don't have any result (_Mag_id = '100' but it can change)

Thank you for your help

[Shubham_Deshmukh]

Put it like this :
_ID={'_MAG_ID'}

[agigliotti · Accepted solution]

let's trying with the below expression:
Sum({<Mouvement_ID={$(vShowMouvement)},Année, Trimestre, Mois, Jour, Date, MoisAnnée, _NIVEAU_GROUPE={'99'},
MonthDiff={"<12"}, MoisAnnéeTM={">=$(vDateMin12)<=$(vDateMax12)"}
>} if( _ID=_MAG_ID, Total_Net_HT) )
i hope it can helps.

[tresesco]

If '_MAG_ID' is a value in the field '_ID', try with single quotes like:

_ID={_MAG_ID}

else, if it's a field itself, you may try like:

_ID={"=_ID=_MAG_ID"}

[Mahmoud]

i tried this but always the same error,

and i tried _ID={'=MAG_ID'}