Indirect set analysis

[#1]

Hi Everybody,

I'm trying to apply a 'double loop' set analysis without success

I'd like to calculate cross selling between Stores: selecting a store I need to see who bought in that store how split the expenses between other stores.So far, all right... What is stucking me is that I'd like to have Stores in dimension seeing for each store both what the customers spent in that store and what spent in the selected store. I've tried with indirect analysis, alternate states, conditional expression but without success. Seems to be impossible to associate to other stores row the expenses in the selected store of common customers.

An example in attach to clarify the scenario

Any idea?

Thank you in advance

Marco

[Gysbert_Wassenaar · Accepted solution]

Try this expression:

pick(match(only({<Store>}Store),$(=concat({<Store>} chr(39) & Store  & chr(39), ',', Store))),

$(=concat({<Store>} '$' & '(=sum({<Customer=P({<Store={' & chr(39) & Store & chr(39) & '}>}Customer)*P({<Store=P(Store)>}Customer)>}Price))', ', ', Store))

)

sillytricksdepartment‌

[satishkurra]

Hi Gysbert

Could you please help me on this thread

I need some help whether we can accommodate this in QlikView.

Expression Help on Current Fiscal Quarter

[#4]

Hi Gysbert,

thank you for your reply and solution, it's clever.

I've tried to apply it to my real case, and also if it hasn't been easy to adapt it, works perfectly!

Thanks

Marco