topic Re: make fied = field in Set Analysis in QlikView

make fied = field in Set Analysis

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

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

Re: make fied = field in Set Analysis

Shubham_Deshmukh — Thu, 07 Mar 2019 10:50:04 GMT

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

Re: make fied = field in Set Analysis

agigliotti — Thu, 07 Mar 2019 10:50:26 GMT

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.

Re: make fied = field in Set Analysis

tresB — Thu, 07 Mar 2019 10:53:45 GMT

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"}

Re: make fied = field in Set Analysis

Mahmoud — Thu, 07 Mar 2019 10:58:53 GMT

i tried this but always the same error,

and i tried _ID={'=MAG_ID'}