Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can we user dimension as expression . Below is the example.
I have an excel sheet as under
Name | Formula |
rahul | =SUM(2+1) |
vilas | =SUM(4+1) |
santosh | =SUM(5+1) |
I have pulled this in qlikview document. Now i have created a table chart and i want to use Fromula column as an expression so that the out put would be as under.
Name | Formula |
rahul | 3 |
vilas | 5 |
santosh | 6 |
Hi, try with :
LOAD
Name,
Evaluate(Formula) as Output_formula
FROM Data.xlsx
(ooxml,embedded labels, table is Sheet1);
Thanks Jean for quick reply , but sorry to say, it isn't working
Sorry, its working. But in the Formula column i wish to use Set analysis expression and that i want to use.
You can´t reuse an expression of one object into another, but you can create a variable with your expression and use this variable into any charts needed
Thanks for the reply. I can create the variables, but there are almost 150 expressions which i need to create to form a single table and creating these many variables is not suitable. I am creating a dash board which has many more KPI's like : Sales, Operations (OEE, OPE, IHR, COPQ), Raw material consumption, Variable costs, fixed costs, HR Related data and so on. In addition to the actual values, i am having budgets of the same as well. Keeping this in mind , i wanted to write expressions in Excel file beside the KPI name , and use the same.
It´s in portuguese, but the example can help you Qlikview utilizando Expressão com origem no Excel
please post a sample application including some data and expressions to test with.
thanks
regards
Marco
use the Only() function
Loading Expressions From File - WITHOUT creating variables in Script
Thank you so much. Can i have the same in English, it will help me in understanding the logic.