topic Re: Dual function / syntax set analysis in QlikView

Dual function / syntax set analysis

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

Hi everybody,

I have problems with the syntax of "dual".

This expression works :

dual(num(sum([SRCES Visites])/sum(TOTAL <Année> [SRCES Visites]),'0%'),sum([SRCES Visites]))

I need to use it in an histogram chart, with the two last years.

First I tried with 2015 and 2016, but it does not work :

dual(num(sum([SRCES Visites])/

sum(TOTAL {<Année = {2015,2016}>} <Année> [SRCES Visites]),'0%'),sum([SRCES Visites]))

Any idea ?

Thank you for your help.

Re: Dual function / syntax set analysis

sunny_talwar — Wed, 25 Jan 2017 13:18:54 GMT

May be add the set analysis before TOTAL <Field> or after?

Dual(Num(Sum([SRCES Visites])/

Sum({<Année = {2015, 2016}>} TOTAL <Année> [SRCES Visites]),'0%'), Sum([SRCES Visites]))

Dual(Num(Sum([SRCES Visites])/

Sum(TOTAL <Année> {<Année = {2015, 2016}>} [SRCES Visites]),'0%'), Sum([SRCES Visites]))

and may be you need this in other places also?

Dual(Num(Sum({<Année = {2015, 2016}>} [SRCES Visites])/sum(TOTAL <Année> {<Année = {2015, 2016}>} [SRCES Visites]),'0%'), Sum({<Année = {2015, 2016}>}[SRCES Visites]))

Re: Dual function / syntax set analysis

marieclaire — Mon, 06 Feb 2017 17:52:16 GMT

Thank you very much Sunny.

The third one is the good one 😉

Dual(Num(Sum({<Année = {2015, 2016}>} [SRCES Visites])/sum(TOTAL <Année> {<Année = {2015, 2016}>} [SRCES Visites]),'0%'), Sum({<Année = {2015, 2016}>}[SRCES Visites]))

Best regards,