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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Annual comparison

Hi,

i´m testing Qlik View so i do not really know how this tool works. My question is if there is a way to compare for example the sales from August 2016 to August 2015 and display it at once?


If yes how to do that or is ther a manual who explains this?

Thanks in advance!

1 Reply
Anil_Babu_Samineni

Yes, You need to create Tabular object wither Straight table or Pivot table or Chart may be Bar Chart

You have to create expressions like. I am assuming you have data till Aug 2016

Sum({<MonthYear = {'>=$(=AddYears(Max(MonthYear),-1)) <=$(=Max(MonthYear))'}>}Sales)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful