topic compare only common data from month vs month or quarter vs quarter in QlikView

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

Tue, 22 Jan 2013 15:57:29 GMT

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!!!

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

christian77 — Tue, 22 Jan 2013 16:07:45 GMT

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.

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

Tue, 22 Jan 2013 17:18:35 GMT

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.

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

Thu, 24 Jan 2013 12:14:42 GMT

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.

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

christian77 — Thu, 24 Jan 2013 12:32:32 GMT

Ok dim, here is the solution.

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

christian77 — Thu, 24 Jan 2013 13:12:19 GMT

the % column

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

Thu, 24 Jan 2013 13:50:06 GMT

thank a lot!!!

you are amazing!

it does exactly what i want it to!!!