can we use chr() function for pickuping the customize value

Karim_Khan — Tue, 25 Aug 2015 11:02:28 GMT

Hello Everyone,

I have below Data.

Sales Level 2	Customer Count	Bookings	% Bookings
	6958	222457000.8	100%
CANADA	631	20932019.92	9.41%
LATIN AMERICA	741	29788670.25	13.39%
US COMMERCIAL	4098	58816212.46	26.44%
US ENTERPRISE	549	51737137	23.26%
US OTHER	3	5475872.92	2.46%
US PS MARKET SEGMENT	1402	55707088.24	25.04%

I wanted to pick up the values from Bookings column.But Booking column is coming from calculated expression.

Is this possible to get the values from calculated columns Data from Char() function or It will work only for Script Level data.

PFB Script

LOAD [End Customer Global Ultimate Name],

Country,

[End Customer HQ Top],

If([Sales Level 2]='EMEAR-EMERGING','EMEAR-REGION' ,

If(Match([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI') OR MATCH([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI','EMEA OTHER','EMEAR-UNALLOCATED'),'EUROPE',[Sales Level 1])) as [Sales Level 1],

[Sales Level 2],

[Sales Level 3],

[Sales Level 4],

[Sales Level 5],

[Partner Name],

[Fiscal Period ID] as Fiscalid,

[Net Bookings],

Re: can we use chr() function for pickuping the customize value

swuehl — Tue, 25 Aug 2015 19:26:26 GMT

I don't understand what you are trying to achieve and how you want chr() to work here.

From where do you want to pick up the values?

If you want to use results from expressions in another expression, you can reference the expression column using

Column() function or stating the expression label "Bookings". Like

="Bookings" * 1.19

Not sure if this is what you are after.

Could you post a small sample QVW?

topic Re: can we use chr() function for pickuping the customize value in QlikView

can we use chr() function for pickuping the customize value

Re: can we use chr() function for pickuping the customize value