Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Max Date by Row?

Hello,

I have the following table:

Month Year=num(monthstart(max(CALE_DATE),1)) =sum({<EVENT={'BACKLOG'},BETA={">=43160"}>} QTY_INC)
Jul-2017429480
Ago-2017429790
Sep-2017430090
Oct-2017430400
Nov-2017430700
Dic-2017431010
Ene-2018431320
Feb-2018431600

The thing is Expression 2 isn't working well, because BETA field value is 43160 (fixed) and it should be the max value from each row (see expression 1).

I used this:

sum({<EVENT={'BACKLOG'},BETA={">=$(=num(monthstart(max(CALE_DATE),1)))"}>} QTY_INC)

Do you know how could I do to use the max for each MonthYear?

Thank you!!!

1 Solution

Accepted Solutions
sunny_talwar

May be using Aggr()

Sum({<EVENT={'BACKLOG'}>} Aggr(If(BETA >= MonthStart(Max(CALE_DATE), 1), Sum({<EVENT={'BACKLOG'}>} QTY_INC)), BETA, [Month Year]))

View solution in original post

2 Replies
sunny_talwar

May be using Aggr()

Sum({<EVENT={'BACKLOG'}>} Aggr(If(BETA >= MonthStart(Max(CALE_DATE), 1), Sum({<EVENT={'BACKLOG'}>} QTY_INC)), BETA, [Month Year]))

Anil_Babu_Samineni

May be this?

sum({<EVENT={'BACKLOG'},BETA={">=$(=num(monthstart(max(TOTAL CALE_DATE),1)))"}>} QTY_INC)


Or else, Can you check this in text box?

num(monthstart(max(TOTAL CALE_DATE),1))

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)