Repeat same value by Dimension

[#1]

Hello Friends,

I have a value (from calculated variable) for one category by date wise. My requirement is to display the same value for each category date wise.

Please find the attached screenshot.

Thanks in Advance,

Siva Srinivas.

[#2]

Hi,

If(isnull(Value),Previous(value),Value)

[Anonymous]

Hi Try using this:

Load the actual table first

and do a resident load like this

if(isnull(Value),Lookup('Value',Category,'A','TableName'),Value)

Hope this helps.

[MarcoWedel]

LOAD Date,
          Category,
          Alt(Value,Peek(Value)) as Value
FROM yoursource;

hope this helps

regards

Marco

[jpapador]

You could load the first table and then join the values on just using date as the key.

Table1:

LOAD

      Date,

      Category

FROM Qvd;

Left Join (Table1)

LOAD

      Date,

      Value

Resident Table1;