Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Is it possible for you to share sample excel file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

 

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!