topic Re: Pick values from other objects in QlikView

Pick values from other objects

Anonymous — Tue, 25 Mar 2014 08:53:56 GMT

Hi,

I have a QlikView document which contains a quite tricky and complex data model. Without going into details about my model, I feel I need to pick a value from another object, as it seems impossible to get the value I want from the ordinary expression in combination with preferred dimensions.

I think it's not possible in QlikView, but I want to ask anyway.. Is it possible to pick values from another object? I would like to have a hidden straight table with some values that I would like to reuse in my presentation object. It's easy to achive what I want in Excel, where I just can pick a value from any cell in my sheet, but is there a similar possibility in QlikView?

Thanks for your answers.

Best regards,

Filip

Re: Pick values from other objects

Tue, 25 Mar 2014 09:09:56 GMT

Hi,

Is it a single value or a list of values?

If it is a single value, might a variable be useful to store parts of your calculation in. Then can you retrieve the content from the variable and use it in your expression.

It might also be useful to hide one or several expressions/columns (depending on graph type), that you in another expression can then use for your complete calculation.

Fredrik

Re: Pick values from other objects

Anonymous — Tue, 25 Mar 2014 09:23:56 GMT

Of course it is a list of values..

How do I include another expression in my expression in the same table object?

Re: Pick values from other objects

Tue, 25 Mar 2014 09:26:19 GMT

You can reference another expression within the same graph object by typing [ExpressionName].