topic Re: repeat value until it changes in QlikView

repeat value until it changes

ali_hijazi — Sun, 19 Jun 2016 02:53:18 GMT

Hello

got a pivot table with dimensions Month-Year and Product

and the expression is FirstsortedValue(Price,-Period_Date)

so far the results are fine and when I select one product i get the following :

However when I select more than one product I get null values in months when there are no purchases for the product as follows:

is there a way to fill for example above for the first product May 2011 with 19 and May 2012 with 16.8282 etc....

Knowing that if I select a third product that might be purchases in April 2011 then I want to fill April 2011 with 19 for product 1 (the first one on the list)

Please advise

Re: repeat value until it changes

Anil_Babu_Samineni — Sun, 19 Jun 2016 05:20:44 GMT

Can you please post one sample Application with Raw data of sample and Expecting O/P as Picture

Then we can understand???

Re: repeat value until it changes

ali_hijazi — Mon, 20 Jun 2016 07:30:56 GMT

The data is something as follows:

Date Product Value

15/2/2016 P1 15.69

25/2/2016 P1 16.5

16/3/2016 P1 17.23

5/7/2016 P1 16.75

....

for the above product I want to display the following:

for Feb 16.5

for Mar 17.23

for Apr,May, June 17.23

and Jul 16.75 and so on...