Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

References

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

Labels (1)
3 Replies
sunny_talwar
MVP
MVP

What is the expression that you are using right now?

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

{<Program>}

Not applicable
Author

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.

sunny_talwar
MVP
MVP

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

Sum({<Program>}M_VALORE_RIGA)/M_FATT_CAMBIO