topic Evaluate an expression in a Straight Table column without fieldvalue() in QlikView

Evaluate an expression in a Straight Table column without fieldvalue()

Mon, 05 Dec 2011 11:53:45 GMT

I can't work out why I can't evaluate an expression in a straight table column without using fieldvalue.

In the attached ExpressionCalc.QVW I have three tables - in the 'working table' I can evaluate the expression in the 'ExprV' field as I would like to. This is a straight table with one row, rotated on its side with the Horizontal checkbox. The expression used is:

=$(= SUBFIELD(fieldValue('ExprV' ,1),'|',2))

ExprV holds expressions prefixed with 'Q' and a number - representing a question number - which are both added to provide uniqueness so that fieldvalue returns the correct value.

Table 2 shows the ExprV as is in the table

Table 3 shows the ExprV as is without the 'Q' prefix - this is the expression I want to evaluate, as in the working table, and not show as the text which it currently does.

Thanks for any help.

Matthew Stephen

Re: Evaluate an expression in a Straight Table column without fieldvalue()

bruno_m_santos — Thu, 11 Oct 2012 10:53:14 GMT

Hi Mathew,

I've a similar probem:

http://community.qlik.com/message/268254

Did you get solve your problem?

Thanks

Bruno

Re: Evaluate an expression in a Straight Table column without fieldvalue()

Thu, 11 Oct 2012 12:39:45 GMT

Hi Bruno

I have no answer – I believe this is not possible.

Matthew Stephen

Solution Consultant UKI

Direct: +44 1926 45 88 88

Mobile: +447557267135

Skype: mattstep1

Email: matthew.stephen@qlik.com

QlikTech UK Ltd

1020 Eskdale Road

RG41 5TS IQ Winnersh

qlik.com<http://www.qlik.com/>

www.businessdiscoverylondon.com

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. QlikTech UK Limited, registered in England and Wales with number 5292408, and whose registered office is Villiers House, Clarendon Avenue, Leamington Spa, Warwickshire, CV32 5PR.