topic Re: Text as part of a function in QlikView

Text as part of a function

Tue, 19 Aug 2014 10:48:49 GMT

Hi guys hoping someone can help not sure what im doing wrong here

I was trying to return the output of a formula and input into an only function but its not working-
, have tried this

Only({<Code={Text(Prop_ID)}>} [$=vlanguage)]))

Thanks

Sarah

jagan — Tue, 19 Aug 2014 10:53:50 GMT

Hi,

Try this

=Only({<Code={'$(=Text(MaxString(Prop_ID)))'}>} [$(vlanguage)])

Regards,

Jagan.

ssanchez — Tue, 19 Aug 2014 11:03:50 GMT

Hi Sarah,

I think it's just a syntax error. Try the following expression:

Only({<Code={$(=Text(Prop_ID))}>} $(vlanguage))

Tue, 19 Aug 2014 11:30:06 GMT

Hi Unfortunately it didn't work must be something im doing - the expressions are all based on the Prop id so not sure if that is the issue

ssanchez — Tue, 19 Aug 2014 11:43:07 GMT

Please can you upload a sample qvw file or show the possible values of Code, Prop_ID and vlanguage?

rbecher — Tue, 19 Aug 2014 11:59:27 GMT

Hi Sarah,

you shoud try this:

Only({<Code={Prop_ID}>} [$(vlanguage)])

rbecher — Tue, 19 Aug 2014 12:00:19 GMT

Btw. {<Code={Prop_ID}>} will not work.