Set Analysis - Intersection

[manojkulkarni]

Hi ,

I need to get the sales from same stores with different period. It should consider the data only for the stores which are active in both the periods, that means consider only common stores between 2 periods. I thought it can be done through intersection of 2 sets. but not sure how it can be done.

Any help will be much appreciated.

[manojkulkarni]

Any help on this, how to use intersection of 2 sets?

[#3]

Hi,

I think u can use Pick and match function.

[#4]

Pick() Function in QlikView

[#5]

The match() Function | Qlikview Cookbook