topic Re: Repeat a Value in QlikView

Repeat a Value

Mon, 24 Apr 2017 17:14:08 GMT

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 — Tue, 25 Apr 2017 01:57:53 GMT

Whar are you expecting on 10 state

prachisangewar — Tue, 25 Apr 2017 02:19:22 GMT

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

Siva_Sankar — Tue, 25 Apr 2017 03:12:47 GMT

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

Siva

Tue, 25 Apr 2017 04:12:06 GMT

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 — Tue, 25 Apr 2017 06:12:00 GMT

Hi,

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

Have a look here:

especially the example on page 10.

Siva_Sankar — Tue, 25 Apr 2017 07:02:16 GMT

Hi Walter,

Can you upload sample data?

siva

ElizaF — Tue, 25 Apr 2017 08:07:07 GMT

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