Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

compare only common data from month vs month or quarter vs quarter

Hi there,

I have a table of customers that contains the customer infromation and a unique customer id for each one of them.

I want to compare the transactions between two time periods, months or quarters but only for the common customers that have a transaction in both of the selected two periods.

Any help would be great.

Thnak you in advance!!!

1 Solution

Accepted Solutions
christian77
Partner - Specialist
Partner - Specialist

6 Replies
christian77
Partner - Specialist
Partner - Specialist

Hi:

Create the table with your 2 expressions, sum({$<Month={ActualMonth}>}ammount) and  sum({$<Month={BeforeMonth}>}ammount).

In the table properties, presentation: Supress cero values.

Not applicable
Author

Hi there.

Thank you for your quick response.

I don't think you understood what i want to display exactly.

I want to select e. q1 in one selection and q2 of 2012 in the other and display in a table box the % difference in the number of transactions, with the customer name as the chart dimension, of the customers that performed transactions in both the selected time periods.

Customer 1 -40%

Customer 2 -50%

Customer 3 +10%

Customer 4 -30%

Customer 5 +20%

.

.

.

.

Customer n +30%

I hope i made it easier for you.

Thank you again.

Not applicable
Author

To make it more clear

Lets say that in february only 10 customers performed transactions

Customer A

Customer B

Customer C

Customer D

Customer E

Customer F

Customer G

Customer H

Customer I

Customer J

annd in march the following 7 customers performed transactions

Customer A

Customer K

Customer L

Customer M

Customer B

Customer D

Customer F

What i want to display is the comparison of only the 4 common customers between the two selected periods, meaning

Customer A

Customer B

Customer D

Customer F

and calculate the % difference in the number of transactions as i displayed in the previous post.

Thank you.

christian77
Partner - Specialist
Partner - Specialist

Ok dim, here is the solution.

christian77
Partner - Specialist
Partner - Specialist

the % column

Not applicable
Author

thank a lot!!!

you are amazing!

it does exactly what i want it to!!!