topic Re: Issue in Previous() Function in QlikView

Issue in Previous() Function

Wed, 05 Sep 2012 05:40:53 GMT

Hi,

How to fill more than one null rows value using previous() function for example

available data

sno date value

1 1/1/2012 600

2 1/2/2012

3 1/3/2012

4 1/4/2012 500

5 1/5/2012 400

6 1/6/2012

7 1/7/2012

8 1/8/2012 200

I used condition in script if(isnull(value),previous(value),value) as value but

it fill one row in value colum, requried result is valuef.

sno date value valuef

1 1/1/2012 600 600

2 1/2/2012 600 600

3 1/3/2012 600

4 1/4/2012 500 500

5 1/5/2012 400 400

6 1/6/2012 400 400

7 1/7/2012 400

8 1/8/2012 200 200

Re: Issue in Previous() Function

thomas_skariah — Wed, 05 Sep 2012 06:10:34 GMT

Hi,

I have created a sample application similar to your scenario,go through it.

Hope this will work for you.

Regards,

Tom

Re: Issue in Previous() Function

whiteline — Wed, 05 Sep 2012 07:15:56 GMT

You shoud use Peek() instead previous().

The first one works with the destination table while the second with te source.

In the source you have null in second row so you get null in third row.

Re: Issue in Previous() Function

Wed, 05 Sep 2012 10:12:39 GMT

Hi Tim,

Can you attach the sample excel file,just to know the purpose of counter field.

Thanks in advance.

Re: Issue in Previous() Function

Wed, 05 Sep 2012 10:50:51 GMT

Thanks for reply but my result still same, plz also let me know how i attach my files.

Regards,

Zain.

Re: Issue in Previous() Function

rajni_batra — Wed, 05 Sep 2012 11:15:29 GMT

why dont u fill these values in traformation step when loading the data.

see the screenshot

hope to help

Re: Issue in Previous() Function

Wed, 05 Sep 2012 12:03:47 GMT

Dear i have exchange rate qvd and i want to attach for your understanding, its clear to you what i want to do.

Regards,

Zain

Re: Issue in Previous() Function

rajni_batra — Wed, 05 Sep 2012 12:06:17 GMT

then do attach that qvd so that could help u more accurately

Re: Issue in Previous() Function

Wed, 05 Sep 2012 12:11:52 GMT

i havnt found attachment option, plz guide me where attachment option, kindly attached snap its easy to me,

Regards,

Zain.

Re: Issue in Previous() Function

rajni_batra — Wed, 05 Sep 2012 12:16:31 GMT

when u choose to reply see right side of the window 'use advance editor'

there is an option below to upload .

from there u can upload ur QVD.

Re: Issue in Previous() Function

Wed, 05 Sep 2012 12:18:34 GMT

Hi Zain,

Use Advance editor to attach files, it is on the top right corner on the compose window. if you select use advance editor then attachment option will be available on bottom of that page.

Re: Issue in Previous() Function

Wed, 05 Sep 2012 12:56:54 GMT

find the attachment

Re: Issue in Previous() Function

rajni_batra — Wed, 05 Sep 2012 13:02:37 GMT

PFA

Re: Issue in Previous() Function

Wed, 05 Sep 2012 13:39:43 GMT

Thanks dear, result is matched.

Regards,

Zain.

Re: Issue in Previous() Function

whiteline — Wed, 05 Sep 2012 14:26:26 GMT

Don't understand why Peek() gives you the same results...

Checked on your data

if(isnull(CCY_RATE), peek(CCY_RATE), CCY_RATE) as CCY_RATE

and everything is fine.

Re: Issue in Previous() Function

Thu, 06 Sep 2012 05:11:15 GMT

Dear Whiteline,

Data is fine i checked, above i attached qvd and application you can also try it and let me know.

Regards,

Zain.

Re: Issue in Previous() Function

whiteline — Thu, 06 Sep 2012 05:23:44 GMT

I said I tried and everithing works fine with peek.

Re: Issue in Previous() Function

Thu, 06 Sep 2012 05:34:16 GMT

Ok fine, can you plz send me an application which you tried with peek.

Regards,

Zain.

Re: Issue in Previous() Function

whiteline — Thu, 06 Sep 2012 05:39:33 GMT

Re: Issue in Previous() Function

Thu, 06 Sep 2012 05:51:00 GMT

Thanks a lot dear, i got what i do mistake.

Zain.