Equivalent of Partition Over concept in qlikview

[vipingarg23]

Hi Team,

Please find the below attachment.

In this attachment, there are a straight table in which two dimensions (A, Week) and one measure (Dup). I am applying concept of partition over of oracle in Qlikview.

In this example, I want Measure(Dup) value for both value of A is 201045 and for B is 201046.

Concept is this....For dimension value A, it should search all value of Week and take maximum of those week value.

Can anyone help me out there?

[sunny_talwar]

Apply the filter within set analysis in addition to TOTAL?

Max(TOTAL <A> {<FieldName = {'FieldValue'}>} Week)

[vipingarg23]

Brilliant Sunny....It is working fine...

You are really genius. Thanks for your help..