Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue in Previous() Function

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

19 Replies
Not applicable

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.

Not applicable

find the attachment

rajni_batra
Specialist
Specialist

Not applicable

Thanks dear, result is matched.

Regards,

Zain.

whiteline
Master II
Master II

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.

Not applicable

Dear Whiteline,

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

Regards,

Zain.

whiteline
Master II
Master II

I said I tried and everithing works fine with peek.

Not applicable

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

Regards,

Zain.

whiteline
Master II
Master II

.

Not applicable

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

Zain.