topic Re: expression in the set analysis in QlikView

expression in the set analysis

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

Hi, I would like to know what I have unblocked in this expression since it does not propose me any result:

sum({$<Priorità={R02}>}($(=vNIpri)))

this is the NIpri variable:

sum(TOTAL <Priorità>{<Obiettivo>}(Effettivo-[Range Min])*100*[Peso Indicatore]/([Range Max]-[Range Min])*[Peso Priorità])

Thank you

Re: expression in the set analysis

PrashantSangle — Wed, 12 Jun 2019 06:09:58 GMT

Check below
1: what is output of variable NIpri in text box.
2: sum({$<Priorità={R02}>}($(=vNIpri))) use " single quote around R02. like
sum({$<Priorità={"R02"}>}($(=vNIpri)))

Regards,

Re: expression in the set analysis

tommasogaiaspa — Wed, 12 Jun 2019 10:34:36 GMT

I tried your solution, but I don't get any results.
I am attaching the qvw test file where you can find the tables with the expressions and the graph with the error.
Thank you.

Re: expression in the set analysis

sunny_talwar — Wed, 12 Jun 2019 11:48:27 GMT

May be try this

Sum({$<Priorità={"R02"}>}Aggr(($(=vNIpri)), Priorità))

Re: expression in the set analysis

tommasogaiaspa — Thu, 13 Jun 2019 08:01:29 GMT

Thanks for the solution