topic Re: References in QlikView

References

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need a hand to set fixed riserimenti for a chart.

I have a billing year divided by 10 different programs, I would like to set up a graph in such a way that if I select only 5 programs, the total turnover in a given year does not change, so you can see the percentage of those five programs over the total turnover one year.

it's possible?

thank you

Re: References

sunny_talwar — Thu, 19 May 2016 16:26:37 GMT

What is the expression that you are using right now?

UPDATE: try ignoring selection in Program field in the denominator expression

{<Program>}

Re: References

Fri, 20 May 2016 10:22:46 GMT

I Haven't a denominator in expression connected to the program.

I calculate the annual revenue and i've a field on the db for the program.

I set two years in the graphic size and program and an expression like this (SUM(M_VALORE_RIGA))/M_FATT_CAMBIO, so when i selected a program it change the annual revenue.

Re: References

sunny_talwar — Fri, 20 May 2016 15:44:17 GMT

I am guessing M_VALORE_RIGA is your Revenue field? May be this:

Sum({<Program>}M_VALORE_RIGA)/M_FATT_CAMBIO