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 · Accepted solution]

Try this

Max(TOTAL <A> Week)

[vipingarg23]

Great Sunny..

It is working fine...But one small issue...It is giving some other values as well for which measure values are zero...Even I am clicking on Presentation tab suppress zero value..it is not suppressing those value..

[sunny_talwar]

Do you have other expression which have values for that row? The row will only go away if all the expressions have 0 or null value. You can force them to be null or 0 using if statement

[vipingarg23]

Yes..All values are 0

[sunny_talwar]

Can you show the image of what you see?

[vipingarg23]

Sorry...one is not zero...Thanks Sunny for your help..

[vipingarg23]

Hi Sunny,

One more question..Is it possible to use the same with set analysis.

[sunny_talwar]

Don't think so... why do you want to use set analysis for this?

[vipingarg23]

As I want to apply one filter for a value.