Repeat a Value

[#1]

Hello,

I have a problems when I'm trying to repeat a value

This is my table box:

I need to repeat PROY_MES to finish the year 2015, MESLANZ indicates the month in which it starts

I have this chart and I need to finish the year repeating the value of PROY_MES for the nexts months

If you have another way to show the information

[Anil_Babu_Samineni]

Whar are you expecting on 10 state

[prachisangewar]

do you mean you need to show the values for all 12 months ?

[Siva_Sankar]

Hi Walter,

Not sure, how you want to fill the missing values. Are you want to fill using previous values?

You can get an idea here Generating the missing data with previous data and with examples here

Generating Missing Data In QlikView

Siva

[#5]

Hi,

What I need is to repeat the value in [PROY_MES] until the end of the year

Example:

Id = 123 [PROY_MES] = 123 MESLANZ=8

MESLANZ = The month that start the project

I need to show the value [PROY_MES] for the months 8,9,10,11 and 12.

It is possible to do from the Expression of the chart?

[ElizaF]

Hi,

You can try the "Slowly Changing Dimensions" concept or AsOfTable concept.

Have a look here:

Slowly Changing Dimensions

especially the example on page 10.

[Siva_Sankar]

Hi Walter,

Can you upload sample data?

siva

[ElizaF]

My guess is NO, especially as it may be affect your app performance.

I thing it is much better second approach - to use the "AsOf table concept as explained in this document

Calculating rolling n-period totals, averages or other aggregations