Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 

Help in set analysis

Hello check the sample data (attached with this post)
I have a project, and billable days with revision number
I want to calculate the total billable days where Revision Type = 0 - Reference Budget or Revision Name = Reference Budget and Revision number is the last one

so in this case the revision number is 4 and the total should be 745
I wrote the following expression:

[Revision Number]={"=[Revision Number] = max({<[Budget Revision Type]={[0 - Reference Budget]}>+<[Budget Revision Name]={[Reference Budget]}>}[Revision Number])"}


[Billbale Days]

but the number is completely wrong


I can walk on water when it freezes
0 Replies