Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
rfigueroa
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:


CH01_20170802_173152.png


Thanks in advance

Roberto

2 Replies
Anil_Babu_Samineni

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
Contributor III
Contributor III
Author

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