Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jose_vargas
Creator
Creator

Use values in other expression

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"

chart1.jpg

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

chart2.jpg

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

5 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi

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

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

jose_vargas
Creator
Creator
Author

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.

variable1.jpg

Please help me, i send my file...

Anil_Babu_Samineni

May be using $(vAbortadaL)

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
jose_vargas
Creator
Creator
Author

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.

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi

Use $(VariableName)