Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rfigueroa
New 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:


CH01_20170802_173152.png


Thanks in advance

Roberto

Tags (2)
2 Replies

Re: Expression to include rows from other groups in Pivot

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)
rfigueroa
New Contributor III

Re: Expression to include rows from other groups in Pivot

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