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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

how do i privot this?

i have 1 dimension and 2 expressions. I fill in the label of the expressions.

Now i drag/drop the expressions to the left of the chart and the dimension to the top.

So, i have on the side my labels (expressions), two rows, one with let say SUM(value1) and below that SUM(value2).

But now i want to distinct from both value1 and value2 actuals and budgets, plus a comparison to the year before.

I can use set analysis to make the distinction, but i dont see how i can split that in this chart?

i could add a dimension with actual and budget, but that is not sufficient because i also need to compare with 2010

1 Reply
amien
Specialist
Specialist
Author

i have added an example..

this is partly what i need .. but now i want to add an expression that adds a comparison

between actual and budget and between actual 2011 and 2010.

i dont mind to create an expression for each team .. but i dont see how to achief this.