Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Expression to include rows from other groups in Pivot

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.

2017-08-02 17_37_53.png

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

Correct report:


Thanks in advance


2 Replies

May be try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor III
Contributor III

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:

2017-08-03 10_35_19.png