topic Re: Concat set and let variables in QlikView

Concat set and let variables

samuel_brierley — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

hopefully should be simple fix here.

I have, say 3 variables in the below arrangement

Let vToken = '123ABC'

Let vName = 'Sam'

Set vHash = =only({< [Date] = {$(vToday)}>}Hash);

i want to then concatenate them into a single variable, this is how i do it but its not working.

Let vData = vToken & vName & vHash

however this returns 123ABCSam=only({< [Date] = {$(vToday)}>}Hash).

does anyone know where ive gone wrong?

ecolomer — Mon, 08 Aug 2016 14:52:07 GMT

See this:

ecolomer — Mon, 08 Aug 2016 14:53:15 GMT

And probably this also:

Mon, 08 Aug 2016 14:54:37 GMT

for use a only on script you need agregate something

example

load Distinc Hash from ... where date = today();

let vHash = peek('Hash',table) ;

Let vData = vToken & vName & vHash

samuel_brierley — Mon, 08 Aug 2016 15:18:11 GMT

Thanks that's got it.

a decent solution