Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am working with Qlikview desktop version 10.0.
I need to make an annual comparative as shown in the picture.
I need the expression to calculate selected data for the year compared to last year's data.
Can yoy help me?.
Thanks.
you can use the time chart wizard
its in the toolbars ->tools-> time chart wizard
its an easy tool to create such graph
you can also use this two expressions:
current year : sum({<YEAR={$(=max(YEAR))}>} Sales)
Previous year : sum({<YEAR={$(=max(YEAR)-1)}>} Sales)
Thank you very much.