Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik users,
How can i get the sum last year data in the green marked zone?
Thanks for all your help.
In this case you have to disregard the year selected, just for experience what is happens, try to make a table with just year and sales. Your expressions are: Year (dim) and Sum(Sales) (exp).
But try this ones: Year (dim) and Sum({<Year>}Sales) (exp).
You see now, this is set analysis.