How to avoid dimension for an expression

[kkkumar82]

Hi Qlikers,

I have a straight table with dimension Product  and have an expression which calculates lowest Transformation for each product, for that I am using an expression -

Sum({<QuarterYear = {$(vNextQuarter),$(vNextQuarter1),$(vNextQuarter2),$(vNextQuarter3)}>}[Transformation Product Actual]*[Transformation Lowest Cost])

/

Sum({<QuarterYear = {$(vNextQuarter),$(vNextQuarter1),$(vNextQuarter2),$(vNextQuarter3)}>}[Product Spend])

Now In the next column I want to have for each product the lowest transformation% across all products.

How to change the above expression so that it gives me the lowest for all products.

I am attaching a sample file for understanding

Thanks

Kiran Kumar

[sunny_talwar]

May be this:

Min(TOTAL Aggr(Sum({<QuarterYear = {$(vNextQuarter),$(vNextQuarter1),$(vNextQuarter2),$(vNextQuarter3)}>}[Transformation Product Actual]*[Transformation Lowest Cost])

/

Sum({<QuarterYear = {$(vNextQuarter),$(vNextQuarter1),$(vNextQuarter2),$(vNextQuarter3)}>}[Product Spend]), Product))

[kkkumar82]

Hi Sunny,

In place of Total I have used All , which one you suggest All or Total.

Thanks

Kiran Kumar

[sunny_talwar]

To tell you the truth, I have never used ALL, so not entirely sure what it does. But I have heard this in the past that ALL might go away in the future versions of QlikView (I do not have any proof or reliable source which can prove that).

I would suggest trying both the expressions (one with TOTAL, other with ALL) and make some selections to see which one gives you the result you are looking for.

HTH

Best,

Sunny

[kkkumar82]

Thanks I will do it.

Kiran Kumar

[sunny_talwar]

Awesome