Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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...