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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

compare data with month from previous year

Hello, I'm relatively new at Qlikview and wanted to compare some data from a selected year with its previous year.

In Qlikview I have a table in which i show the count of all the contacts there have been with the customer per mount [=count(contactsID)] with the dimension [contacts.month]

I want to show an other expression with the contacts with customers in the same month a year before.

So if my table shows all the contacts from jan-2014 until dec-2014 I want a bar next to every month with the months jan-2013 until dec-2013

for example jan-2013/jan-2014; feb-2013/feb-2014; etc

If anybody could help i would be very grateful! Thanks to all of you in advance!

10 Replies
Not applicable
Author

Thank you! i did know that i could use more expressions. Didn't knew how to create the 2nd one. But now i do!