Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis: to Show Common Stores between two consecutive months

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

YearMonthStores OverAll#Common Stores
2018016990
2018021000300
201803700500

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

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

Please suggest

5 Replies
ogautier62
Specialist II
Specialist II

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
Not applicable
Author

can you provide a sample

qlikviewwizard
Master II
Master II

Can you attach the sample data and expected result?

Anonymous
Not applicable
Author

no I cant due to security reasons

qlikviewwizard
Master II
Master II

You can send some sample data instead of original data.