Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Repeating the values in a straight table/Pivot table

Hi guys

I have a straight table as :

Product_CodeCalendarMonthStandardCostQ
5002041Jan194567.7793
Feb0108
Mar0114
Apr092
May052
Jun056
Jul092
Aug0107
Sep96240.1569
Oct0147
Nov090
Dec0136

I want the output as :

Product_CodeCalendarMonthStandardCostQ
5002041Jan194567.7793
Feb194567.77108
Mar194567.77114
Apr194567.7792
May194567.7752
Jun194567.7756
Jul194567.7792
Aug194567.77107
Sep96240.1569
Oct96240.15147
Nov96240.1590
Dec96240.15136
3 Replies
bill_markham
Not applicable

Re: Repeating the values in a straight table/Pivot table

Manish

I would look at sorting that in the load script, probably using the Previous() and maybe Order By, depending on your raw input data.

Best Regards,     Bill

Not applicable

Re: Repeating the values in a straight table/Pivot table

As far as Raw data is concerned , i have 2 tables ..

First Table looks like :

ProductCodeMonth YearStandardCost
5002041Jan-13194567.77
5002041Sep-1396240.15

and Second

ProductCodeMonth YearQauntity
5002041Jan-1393
5002041Feb-13108
5002041Mar-13114
5002041Apr-1392
5002041May-1352
5002041Jun-1356
5002041Jul-1392
5002041Aug-13107
5002041Sep-1369
5002041Oct-13147
5002041Nov-1390
5002041Dec-13136
bill_markham
Not applicable

Re: Re: Repeating the values in a straight table/Pivot table

Manish

Is the attached qvw the sort of thing you were after ?

Best Regards,     Bill