topic Repeat same value by Dimension in QlikView

Repeat same value by Dimension

Tue, 21 Oct 2014 13:58:12 GMT

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.

Tue, 21 Oct 2014 14:12:24 GMT

Hi,

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

Anonymous — Tue, 21 Oct 2014 14:31:52 GMT

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 — Tue, 21 Oct 2014 15:13:07 GMT

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

hope this helps

regards

Marco

jpapador — Tue, 21 Oct 2014 15:19:18 GMT

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

Table1:

LOAD

Date,