counting documents with if criteria

[#1]

Hi,

i despair of this... i'm trying to count Documents with a if-condition in a Text-Field. in a table i also created i set a boolean 1, if date one is higher then date today(). (just to check if my text-field counting works)  The Dimension of this table are the document numbers.

in the textfield i'm unable to run the same expression

if(today()>=max([Bestellungen.Date of Shipment])+45,1,0)

i need the max() statement, because every document contains a few [Date of Shipment] - Dates and i only need the highest.

i hope you can understand what my problem is, thank you for your help!

Best,

Tim

[#2]

Hi,

Could you please upload the sample file?

[#3]

Hi,

here is the sample file!

thank you!

[rwunderlich]

If you want to do the count in the dimensionless textbox, you need to use aggr() to tell QV what to iterate over. So reusing your working expression from the chart.

=sum(aggr(if(max([max. Verschiffung])+45<= today(),1,0),[Bestellungen.Document No_]))

Or simplifying it a bit:

=sum(

  aggr(

    -max([max. Verschiffung])+45<= today()

  ,[Bestellungen.Document No_])

)

-Rob