topic Re: Computing for Days Delayed in QlikView

Computing for Days Delayed

Tue, 15 Jan 2013 02:50:27 GMT

Hello,

I would like to compute for the days delayed in my file. The problem is, the date that I have to compute is only located in 1 field.

Please see attached file!

Thanks,

Donna

********************[UPDATE]****************************

Since we can now compute the days delayed (answer provided by Flipside).. I have a situation which I have to input in an input box,

ex: Days Delayed [input box]: 3, if I input a number, it will only display the days delayed which is equal to 3.

is this possible?

Thanks a bunch!

-Dona

Re: Computing for Days Delayed

flipside — Tue, 15 Jan 2013 09:38:31 GMT

Hi Donna,

If I've understood correctly, I think this is what you can do in an expression ..

=if(left(no#,1)='b',date-aggr(min(total <id> date), id, no#))

.. however wouldn't it be easier to associate the dates in script?

I'm assuming you only have 2 dates (a & b).

flipside

Re: Computing for Days Delayed

Wed, 16 Jan 2013 03:12:22 GMT

worked like a charm!

thank you flipside!

it gave me an idea

Re: Computing for Days Delayed

Thu, 07 Mar 2013 03:11:51 GMT

Hi flipside!

I got a question regarding this one!

Since we can now compute the days delayed.. I have a situation which I have to input in an input box,

ex: Days Delayed [input box]: 3, if I input a number, it will only display the days delayed which is equal to 3.

is this possible?

Thanks a bunch!

-Dona

Re: Computing for Days Delayed

Thu, 07 Mar 2013 08:33:23 GMT

b.u.m.p~

Re: Computing for Days Delayed

flipside — Thu, 07 Mar 2013 09:37:01 GMT

If you have no other expressions, then you could amend the formula as ...

=if( if(left(no#,1)='b',date-aggr(min(total <id> date), id, no#)) =daysDelayed,daysDelayed+.001)

... I have added 0.001 to the value and set the number presentation to integer to force zeroes to show if you need them to.

If you have to have other expressions, then the only way might be to set the background colour in the expression to highlight the matching values.

flipside

EDIT: Where daysDelayed is the variable linked to your input box! Should have made that clear!

Re: Computing for Days Delayed

Fri, 08 Mar 2013 01:38:31 GMT

up!

Re: Computing for Days Delayed

Fri, 08 Mar 2013 01:53:12 GMT

Hi!

Thanks for the reply! is it possible that if I input something on the input box, it will only show the items that the value of days delayed inputted?

ex: if I input days delayed : 2

then it will only show all the days delayed for 2 days

Thanks!

Re: Computing for Days Delayed

flipside — Fri, 08 Mar 2013 09:30:50 GMT

My earlier reply should give you that - does it not work for you?

=if(if(left(no#,1)='b',date-aggr(min(total <id> date), id, no#))=daysDelayed,daysDelayed+.001)

... the original formula (in italics) is used inside another if statement (the bold part) and it just checks if the formula equals the inputted value (I'm using daysDelayed as my variable name). If there is a match then return the formula (I added 0.001 to force zeroes to show) else do nothing - ie. return Null().

If this is the ONLY expression, then the table should reduce to only those valid rows, but if other expressions are in effect then THIS expression may show as a Null value.

flipside

Re: Computing for Days Delayed

Sun, 10 Mar 2013 07:51:47 GMT

it works. alright, i'll get back to you as soon as I get back on that expression. Thanks!

Re: Computing for Days Delayed

Mon, 11 Mar 2013 01:02:58 GMT

thanks flipside! it works! now my only problem is to show also the date it was shipped. are there possible ways to show it on the dimension without getting the 'error in calculation'?

thanks!!

Re: Computing for Days Delayed

Thu, 14 Mar 2013 01:58:48 GMT

up~