topic Re: Count if in QlikView

Count if

Fri, 19 Oct 2012 08:34:24 GMT

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.

Re: Count if

deepakk — Fri, 19 Oct 2012 08:56:23 GMT

hi,

Try this code.

if(count([Delay Days]>0,1)

Deepak

Re: Count if

Fri, 19 Oct 2012 08:59:34 GMT

Maybe there is a syntax error because the comma between 0 and 1 is underlined red.

M4rk0

Re: Count if

Gysbert_Wassenaar — Fri, 19 Oct 2012 09:03:31 GMT

=count({$<[Delay Days]={'>0'} > } [Sales Order Line])

Re: Count if

Fri, 19 Oct 2012 09:28:51 GMT

How Can I identify the Sales Order Line ?

Re: Count if

Gysbert_Wassenaar — Fri, 19 Oct 2012 09:42:29 GMT

No idea, it's your data model not mine. If you say you want to count the sales order lines with a delay > 0 then I assume your data model has an entity sales order line.

Re: Count if

Fri, 19 Oct 2012 10:47:45 GMT

Correct !! 🙂 But seems that works well with the Dimensions but doesn't works with Expressions. The formula gives me tha total Sales Lines. 😞

Re: Count if

Gysbert_Wassenaar — Fri, 19 Oct 2012 10:56:00 GMT

How do you calculate delay days? Can you share the qvw document you're working on?

Re: Count if

Fri, 19 Oct 2012 12:07:15 GMT

I have two dates

Working days and Solar Days

Delay Working Days

If([Confirmation Date]<[Creation Date],NetWorkDays([Confirmation Date], [Creation Date]),'-' & NetWorkDays([Creation Date],[Confirmation Date]))

Delay Solar Days

=[Creation Date] - [Confirmation Date]

I can't send you the file because is gather information direct from SQL Server.

Re: Count if

Fri, 19 Oct 2012 12:14:39 GMT

Comments in English,

thanks

Re: Count if

Gysbert_Wassenaar — Fri, 19 Oct 2012 12:43:31 GMT

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.

Re: Count if

sakamsureshbabu — Fri, 28 Nov 2014 07:55:57 GMT

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...