Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Only customers appearing in the same period. How?

Hi.

I'm moving my very first steps with Qlik.
I have a table with these info:

- Transaction date (from jan 2013 till mar 2014).

- Customer ID

- Store ID

- Value

My draft dashboard allows to select months and/or weeks to show comparison Values for 2013 and 2014.

How can I show comparison values just for the customer IDs which have at least a transaction in both periods?

Thank you very much in advance.

G

2 Replies
Not applicable

Re: Only customers appearing in the same period. How?

Could you share a sample qvw?

Not applicable

Re: Re: Only customers appearing in the same period. How?

Hi Robert,

I'm not able at the moment but I can share some data with you.

Transaction dateCustomer IDStore IDValueYearMonthWeek
01/02/20131232120201325
26/02/20131231150201329
23/03/201354621442013312
17/04/201345621242013416
12/05/201345611302013520
06/06/201378921222013623
01/07/201378921162013727
26/07/201312311022013730
20/08/201312311492013834
14/09/201312321372013937
09/10/2013123214420131041
03/11/2013456211420131145
28/11/2013456214720131148
23/12/2013879114320131252
17/01/20144562124201413
11/02/20144562126201427
08/03/201478921252014310
02/04/201478911222014414
27/04/201412311342014418
22/05/201412321072014521
16/06/201412321022014625
11/07/201412311432014728
05/08/201445611142014832
30/08/201478911462014835
24/09/201478911122014939
19/10/2014123110520141043
13/11/2014123212420141146
08/12/2014123113620141250

If i choose Month = 2, I should have a result like this:

20132014
Store IdHow many customers?ValuesHow many customers?ValuesAppearing in the same period?Values AITSP
111500000
21120112600
Totale complessivo2270112600

If I choose Month = 7

20132014
Store IdHow many customers?ValuesHow many customers?ValuesAppearing in the same period?Values AITSP
11143001143
222180000
Totale complessivo221811431143
Community Browser