Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Reference variable from excel under a column to the expression in the straight table

Hi All,

I am trying to refer a column in a excel which has the variable names stored in it.

   

KPI NameKPICalculationVariable
KPI1vKPI1Calculation
KPI2vKPI2Calculation
KPI3vKPI3Calculation

I want a straight table where we have the KPI Name and the KPI values evaluated. I do not want to use nested if to evaluate the expression for KPI value as there are about 50 KPIs

Could anyone help?

Thanks

Abhishek

4 Replies

Re: Reference variable from excel under a column to the expression in the straight table

Dear Abhishek,

Sorry but I am not getting what you want.

Can you please explain in detail with some example and sample data.

Regards,

Kaushik Solanki

Not applicable

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)

Straight Table:

KPI Name KPICalculationVariable
KPI1 $21
KPI2 $1,000
KPI3 $1,000

Sorry for the bad formatting.

Thanks

Abhishek

Re: Reference variable from excel under a column to the expression in the straight table

Is it possible for you to share sample excel file.

Regards,

Kaushik Solanki

Not applicable

Re: Reference variable from excel under a column to the expression in the straight table

 

Variables definition in the QVW file is like this:

vKPI1CalculationSUM(KPI1)
vKPI2CalculationSUM(KPI2)
vKPI3CalculationSUM(KPI3)

have attached a sample excel. Cannot share the original file here.

Thanks for the help!

Community Browser