topic Set Analysis In Expression in QlikView

Set Analysis In Expression

Mon, 25 Jul 2011 21:50:28 GMT

Hi There

Can we have set analysis as expression of a chart based on a dimension?

In my app, I have quarterly sales person quota. Quota table is not associated to sales table. In my sales analysis chart, I would like to compare sales versus quota. In dimension, I have quarter and in sales expression I have sum (salesamount). For quota expression, can I have sum( {$<QuotaQuarter={SalesQuarter}>} Quota)?

Thanks

Set Analysis In Expression

danielrozental — Tue, 26 Jul 2011 01:36:07 GMT

If you are selecting a Sales Quarter first then your expression should look like this

sum( {$<QuotaQuarter=P(SalesQuarter)>} Quota)

On the contrary, if you don't want to force a Quarter selection then your expression should be like this.

sum( if(QuotaQuarter=SalesQuarter, Quota))

This will probably not work that great unless you do a sum distinct, it might be a good idea if you can post a sample qvw.