Set analytics compare

Thu, 14 Jun 2012 09:47:01 GMT

Hello,

I have a question about the set analytics function and using it in charts.

I have the following definitons:

SUM( {$<JAARLANG={2011}, StoreCity={'Amsterdam'}>} SalesPriceBrut )

and

SUM( {$<JAARLANG={2011}, StoreCity={'Amsterdam'}>} SalesPriceBrut )

Which give me these fields:

That's perfect

I want to do two things :

Lock this information. No other selection should affect these fields. How can I do that?

and

Compare this selection with other stores in the same layout . When I add this definiton:

SUM( {$<JAARLANG={2011}>} SalesPriceBrut )

Qlikview creates a field at the right next to my previous definitons. I want this field with other stores underneath my 'static' selection. Is that possible?

thanks!

topic Set analytics compare in QlikView

Set analytics compare