topic Re: Indirect set analysis in QlikView

Indirect set analysis

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Indirect set analysis

Gysbert_Wassenaar — Sun, 30 Apr 2017 16:11:23 GMT

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‌

Re: Indirect set analysis

satishkurra — Sun, 30 Apr 2017 16:59:19 GMT

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

Re: Indirect set analysis

Tue, 16 May 2017 07:55:25 GMT

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