topic Set Analysis with modifier in QlikView

Set Analysis with modifier

Anonymous — Sat, 16 Jan 2016 01:40:53 GMT

I have the following calculated dimension:

i need to add the following set modifier to the expression:

[New Product Indicator] = 'YES'

How can the above calculated dimension be modified to accommodate the above?

Regards.

sunny_talwar — Sat, 16 Jan 2016 02:35:40 GMT

May be this:

=Aggr(If(Rank(Sum({<[New Product Indicator] = {'YES'}>} Amount)) <= 20, [Drug Name]), [Drug Name])

Anonymous — Sat, 16 Jan 2016 03:07:13 GMT

Thanks Sunny