topic Save variable in a field and use it as variable in QlikView

Save variable in a field and use it as variable

fyyjulien — Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

In my project, customer need to see some kpi in a simple table and every row correspond one kpi, and all kpi can be controlled by filter.

So I use now the function pick(match) to realize this, it means, for example, if the kpi is on 4th row, so we show the 4th kpi.

But it's not easy to maintain.

So I want to know:

Is there a way to use a field like varible or expression?

For exemple:

I have a table like:

Title Order Expression

Title_1 1 ${vVariable1}

Title_2 2 ${vVariable2}

Title_3 3 ${vVariable3}

these varible are already in the application, so my question, is it possible to use field 'expression' like a variable, not just a string?

Thanks very much in advance.

pradosh_thakur — Fri, 29 Dec 2017 18:09:18 GMT

I guess its possible

May be this. Let me know if you have any other requirement and i understood it wrong.

pradosh_thakur — Fri, 29 Dec 2017 18:12:19 GMT

May be this. Let me know if you have any other requirement and i understood it wrong.

fyyjulien — Wed, 31 Jan 2018 08:25:33 GMT

Thank you so much, Pradosh,

It's a good solution, I just change a little your app to correspond my client's request.

Sorry for my answer so late, I forgot to clik the button to send this message to you.

Julien Fan