Set Analysis: to Show Common Stores between two consecutive months

[Anonymous]

Hi All,

I need to show only common stores between two consecutive months .

Jan to Feb, Feb to March, March to April and so on ... using set analysis..

YearMonth	Stores OverAll	#Common Stores
201801	699	0
201802	1000	300
201803	700	500

MonthNum: 1,2 3,.....

=count(Distinct {<MonthNum={'$(=vCurrentMonth)' or MonthNum={'$(=vLastMonth)'>}>}StoreCode)

Please suggest

[ogautier62]

Hi,

one idea :

make a pivot table with yearmonth and storecode (in horizontal)

then expression :

above(count(distinct storecode))  // storecode present prior month

and you sum it

regards

[Anonymous]

can you provide a sample

[qlikviewwizard]

Can you attach the sample data and expected result?

[Anonymous]

no I cant due to security reasons

[qlikviewwizard]

You can send some sample data instead of original data.