Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

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
Author

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
Anonymous
Not applicable
Author

Manish

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

Best Regards,     Bill