topic Re: Expression to include rows from other groups in Pivot in QlikView

Expression to include rows from other groups in Pivot

rfigueroa — Wed, 02 Aug 2017 22:49:41 GMT

Hi all.

In this sample, on the column No_Alloc I want an expression to COUNT all rows which are

[AllocateMonth] > [InitMonth]

but also including those records where [InitMonth] is less or equal than the current.

So for example, in the row InitMonth = 201609, No_Alloc should be 7.

Correct report:

Thanks in advance

Roberto

Anil_Babu_Samineni — Thu, 03 Aug 2017 02:00:37 GMT

May be try this?

=Count(If(AllocateMonth > InitMonth and InitMonth <= Max(TOTAL AllocateMonth),GrpID))

rfigueroa — Thu, 03 Aug 2017 17:48:29 GMT

Thanks but it doesn't work.

I'm expecting in the first 4 rows the values: 5,6,7,7

This is what I get with your expression: