topic Re: Use values in other expression in QlikView

Use values in other expression

jose_vargas — Tue, 03 Jan 2017 15:17:04 GMT

Hello.

I Have 3 differents charts, 2 of them have an expression and in 3rd one i want to show the sum of chart 1 + chart 2.

Example.

This is my chart1. the expression is "Abortada por Usuarios L"

This is my chart 2. the expression is "Abortada por Usuarios P"

And in this 3rd chart i want to SUM the expression "Abortada por Usuarios L" (from chart1) + "Abortada por Usuarios P" (from chart2). How can i do?

I cant just sum by formula copy and paste the formula of each expression, because each one have a different logic and filters. For that a ineed just to sum the values.

Sorry for my english, i hope you understand

Thanks

Re: Use values in other expression

krishnacbe — Tue, 03 Jan 2017 15:18:36 GMT

You can create variable and store the expression in first & second chart.

Then use the variable names to sum it in third chart.

Re: Use values in other expression

jose_vargas — Tue, 03 Jan 2017 15:29:08 GMT

How should i use variables?

I create variable and paste the formula, and when i call the variable, that show me text and not value.

Please help me, i send my file...

Re: Use values in other expression

Anil_Babu_Samineni — Tue, 03 Jan 2017 15:34:51 GMT

May be using $(vAbortadaL)

Try to change as per your Variable or else please share the expression for that variable

Re: Use values in other expression

jose_vargas — Tue, 03 Jan 2017 15:54:15 GMT

I use variables, but its just copy the formula and not the value, is the same that i use formula directly. I cant do that because each chart have a different logic, so i need to capture the value not formula.

Re: Use values in other expression

krishnacbe — Tue, 03 Jan 2017 15:59:40 GMT

Use $(VariableName)