Count if

[#1]

Hi Experts,

I'm a QlikView Newbie and I need your help.

I have a Straight Table with all Sales Orders and for each line I have an expression with the

delay shipment days.

How Can I count how many Sales Order Lines are in delay ?

I tried

Count([Delay Days] > '0')         -> Doesn't work

=Count({$<[Delay Days]>0>)   -> Doesn't work

Where Delay Days is an Expression belowing Sales Straight Table.

Thanks a lot.

[Gysbert_Wassenaar]

The best solution in my opinion is to calculate these two fields in the load script. That way you can use them as dimensions in a set analysis expression. It's probably better for performance too.

[sakamsureshbabu]

hi Gysbert

i am use this exp 

count({$<[MASTER REFERENCE CATEGORY CODE]={'>1'} > } [BILL DATE])

for counting no.of days in month base and also selected rang base

How can i use this...