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

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!