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

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

Wed, 20 Apr 2016 08:02:54 GMT

Hi All,

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

KPI Name	KPICalculationVariable
KPI1	vKPI1Calculation
KPI2	vKPI2Calculation
KPI3	vKPI3Calculation

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

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

kaushiknsolanki — Wed, 20 Apr 2016 08:10:32 GMT

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

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

Wed, 20 Apr 2016 08:21:05 GMT

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

kaushiknsolanki — Wed, 20 Apr 2016 08:23:57 GMT

Is it possible for you to share sample excel file.

Regards,

Kaushik Solanki

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

Wed, 20 Apr 2016 08:33:42 GMT

Variables definition in the QVW file is like this:

vKPI1Calculation	SUM(KPI1)
vKPI2Calculation	SUM(KPI2)
vKPI3Calculation	SUM(KPI3)

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

Thanks for the help!