topic Re: Using alias columns to create measures in QlikView

Using alias columns to create measures

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I did alias for the column names

like( POCKET_MARGIN as POCKET_MARGIN1)

and now i want to use to create a measure by using pocket_margin1 like ( invoice_price1*pocket_margin1)

i have stored the table in a qvd and loaded the data from qvd and from that columns i created the measure

but it is showing field not found error.

thanks in advance

Re: Using alias columns to create measures

sunny_talwar — Wed, 16 Nov 2016 12:37:44 GMT

Can you share the exact script you are using?

Re: Using alias columns to create measures

Wed, 16 Nov 2016 12:44:38 GMT

i can't share the whole script but

POCKET_MARGIN ,

STANDARD_MARGIN,

STANDARD_MARGIN ,

POCKET_MARGIN,

SHIPPED_QUANTITY,

INVOICE_PRICE ,

STANDARD_COST ,

STANDARD_COST,

POCKET_MARGIN as POCKET_MARGIN1,

STANDARD_MARGIN as STANDARD_MARGIN1,

STANDARD_MARGIN as STANDARD_MARGIN2,

POCKET_MARGIN as POCKET_MARGIN2,

SHIPPED_QUANTITY as SHIPPED_QUANTITY1,

SHIPPED_QUANTITY as SHIPPED_QUANTITY2,

INVOICE_PRICE as INVOICE_PRICE1,

INVOICE_PRICE as INVOICE_PRICE2,

STANDARD_COST as STANDARD_COST1,

STANDARD_COST as STANDARD_COST2;

SQL SELECT *

FROM PRICING."PRICING_PROFITABILITY" ;

Margin_walk:

load

POCKET_MARGIN1,

STANDARD_MARGIN1,

STANDARD_MARGIN2,

POCKET_MARGIN2,

SHIPPED_QUANTITY1,

SHIPPED_QUANTITY2,

INVOICE_PRICE1,

INVOICE_PRICE2,

STANDARD_COST1,

STANDARD_COST2

RESIDENT PRICING_PROFITABILITY;

STORE [Margin_walk] INTO 'C:\pricing_profitability\Test.qvd' (qvd);

Contribution:

load

[(INVOICE_PRICE2/SHIPPED_QUANTITY2)] as price_contribution

from 'C:\pricing_profitability\Test.qvd';

Re: Using alias columns to create measures

sunny_talwar — Wed, 16 Nov 2016 12:54:55 GMT

Why are you adding square brackets here?

Contribution:

load

[(INVOICE_PRICE2/SHIPPED_QUANTITY2)] as price_contribution

from 'C:\pricing_profitability\Test.qvd';

Try this may be:

Contribution:

LOAD (INVOICE_PRICE2/SHIPPED_QUANTITY2) as price_contribution

FROM 'C:\pricing_profitability\Test.qvd';

Re: Using alias columns to create measures

Wed, 16 Nov 2016 13:01:16 GMT

thanks for the reply

I removed the square brackets and i reloaded it,but it is giving the same issue

Re: Using alias columns to create measures

Anil_Babu_Samineni — Wed, 16 Nov 2016 14:14:39 GMT

Can you check whether these values are stored in qvd/not. If so, Check in list box then tell me.

INVOICE_PRICE2 & SHIPPED_QUANTITY2

Re: Using alias columns to create measures

sunny_talwar — Wed, 16 Nov 2016 14:15:58 GMT

What is the exact error you are seeing?

Re: Using alias columns to create measures

Thu, 17 Nov 2016 06:20:39 GMT

NO, the columns are not stored in QVD

can you please suggest me the correct way to do it

Re: Using alias columns to create measures

Thu, 17 Nov 2016 06:23:36 GMT

Re: Using alias columns to create measures

Chanty4u — Thu, 17 Nov 2016 06:25:30 GMT

Filed Names and fieldValues are case sensitive.

Is checked or not? in your actual data?

Re: Using alias columns to create measures

tamilarasu — Thu, 17 Nov 2016 06:36:49 GMT

Hi Srilatha,

Try this,

LOAD (INVOICE_PRICE2/SHIPPED_QUANTITY2) as price_contribution

FROM 'C:\pricing_profitability\Test.qvd' (qvd) ;

Or simply

LOAD (INVOICE_PRICE2/SHIPPED_QUANTITY2) as price_contribution

FROM C:\pricing_profitability\Test.qvd (qvd) ;

Re: Using alias columns to create measures

Thu, 17 Nov 2016 06:49:31 GMT

Thank you

It worked fine