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?

[Peter_Cammaert]

Are you sure you want to both aggregate Week and partition by Week?

[vipingarg23]

Sorry for my mistake..Both are different field

MAX(Sum(Create_Week))

        OVER(

            PARTITION BY

                "Item",

                "RU",

                "Week"

        )

[Peter_Cammaert]

How about:

=Max(total Aggr(Sum(Create_Week), Item, RU, Week))

[vipingarg23]

No.It Is not working as well.

[vipingarg23]

Antonio, can you pls give me the full expression as I am not able to understand it?

[Peter_Cammaert]

That happens if we're not getting the full details of the context. We have to do a lot of guesswork.

Can you post an example document in which you place your target object and describe the expected outcome? That would make it easier to find a solution right-away. Thanks.

[marcus_sommer]

I think the suggestion from Peter goes in the right direction. Please try it again and if it didn't work you need to provide some more context to how should the table look like, which dimensions are included and also some data to it and which result is expected from them.

- Marcus