Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Repeat same value by Dimension

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.

4 Replies
Not applicable
Author

Hi,

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

Anonymous
Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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;