Eqivalent of partition in Qlikview

[vipingarg23]

Hi All,

I need Qlikview UI  equivalent of below sql code ::

MAX(Sum(Week))

        OVER(

            PARTITION BY

                "Item",

                "RU",

                "Week"

        )

I need to implement it in UI part not in script part. Is it possible?

[Anil_Babu_Samineni]

Try this?

Table:

Load Item, RU, Week from Table;

Left Join (Table)

Load Item, RU, Week, Sum(Week) as Week_All Resident Table Group By Item, RU, Week;

Left Join (Table)

Load Item, RU, Week, Week_All, Max(Week_All) as Max_Week_All Resident Table Group By Item, RU, Week;

[vipingarg23]

Thanks Anil,

But I need to implement the same on UI part. For this I have to change the script.

[Anil_Babu_Samineni]

Is there any difficult to change in script, Because UI restrict some functionality like Max(Sum(Measure))

[vipingarg23]

Yes Anil, I can't change the code right now. No problem..Thanks for your help.

[Peter_Cammaert]

What for? Straight table? Pivot table? Text box? The search object? The QlikView UI is composed exclusively of visualization objects, not queries. It would be good to know where you plan to use your analogue.

[vipingarg23]

It is for Straight Table

[Peter_Cammaert]

Fields Item, RU and Week are Dimensions in your Straight table?

[antoniotiman]

May be like this (QV 12)

Aggr(RowNo(),(Product,(Numeric,Asc)),(Date,(Numeric,Asc)))

[vipingarg23]

Yes..All are dimensions in my straight table.