topic Re: counting documents with if criteria in QlikView

counting documents with if criteria

Fri, 19 Dec 2014 14:13:27 GMT

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

Re: counting documents with if criteria

Fri, 19 Dec 2014 14:29:44 GMT

Hi,

Could you please upload the sample file?

Re: counting documents with if criteria

Fri, 19 Dec 2014 15:12:05 GMT

Hi,

here is the sample file!

thank you!

Re: counting documents with if criteria

rwunderlich — Fri, 19 Dec 2014 19:47:13 GMT

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