Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)