Re: Reference variable from excel under a column to the expression in the straight table
I want to refer the column KPICalculationVariable in my expression.
I want a straight table where "KPI Name" will be a dimension and KPICalculationVariable as an expression. The column KPICalculationVariable should be able to fetch the variables like vKPI1Calculation, vKPI2Calculation, vKPI3Calculation and evaluate the same for each "KPI Name"
as shown below (Variables vKPI1Calculation, vKPI2Calculation, vKPI3Calculation are created in QlikView Dashboard file)