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

Announcements
Annual Conference: Turn data into bold moves, April 13 -15: Learn More!
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.