Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

counting documents with if criteria

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

3 Replies
Not applicable

Re: counting documents with if criteria

Hi,

Could you please upload the sample file?

Not applicable

Re: counting documents with if criteria

Hi,

here is the sample file!

thank you!

Re: counting documents with if criteria

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

Community Browser