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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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

3 Replies
sunny_talwar

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

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

Sum({<Program>}M_VALORE_RIGA)/M_FATT_CAMBIO