topic Re: Need help in interval function in QlikView

Need help in interval function

Fri, 11 Jan 2013 11:11:08 GMT

Hello Friends,

I would like to find the difference between two delivery in day1 and day 2.

I tried a expression as in the below like

=Interval(Count({<DELAI={'day1'}>}Number),Count({<DELAI={'day2'}>}Number)), as I am getting only day1 value.

Could you please me .....

Regards

Ammu

Re: Need help in interval function

swuehl — Fri, 11 Jan 2013 11:15:46 GMT

interval(expression [ , format-code ])

The interval function formats the expression as a time interval according to the string given as a format-code. If the format code is omitted, the time format set in the operating system is used. Intervals may be formatted as a time, as days or as a combination of days, hours, minutes, seconds and fractions of seconds.

You are using two arguments, so QV tries to interprete your second argument as format code (which must be a format code string).

If you want to get the difference in days, you need to use a subtraction of your counts (if counting is correct here).

Re: Need help in interval function

Fri, 11 Jan 2013 11:44:51 GMT

Hello Swuehl,

Thanks for your reply and the explanation about interval is awesome.

I tried the following, it works fine.

=Count({<DELAI={'day1'}>}Number)-Count({<DELAI={'day2'}>}Number).

If I have day3 means I need to add the same Count expression.

My question is it possible to do in a single expression like Count({<DELAI={day1-day2-day3}>}Number)

Hope, I am clear.

Thanks in advnce.

Regards

Ammu

Re: Need help in interval function

swuehl — Fri, 11 Jan 2013 11:57:08 GMT

I am not quite clear how you are calculating a timespan by counting your number field, I am just assuming something and I think you need to use three different counts:

=Count({<DELAI={'day1'}>}Number) - Count({<DELAI={'day2'}>}Number) - Count({<DELAI={'day3'}>}Number)

Thanks for your reply and the explanation about interval is awesome.

Thanks, but that's just copied from the HELP 😉

Re: Need help in interval function

Sat, 10 Aug 2013 18:16:19 GMT

Please help me.

I have exam data of a class of 50 students.

Now I want to calculate the average (and, median) of top 80% students of that class.

How can I do that?
Please help.

Thanks.