Discussion board where members can get started with QlikView.
I have below Data.
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.
LOAD [End Customer Global Ultimate Name],
[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],
[Fiscal Period ID] as Fiscalid,
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?