Concat set and let variables

[samuel_brierley]

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]

See this:

The Magic of Variables

[ecolomer]

And probably this also:

https://community.qlik.com/blogs/qlikviewdesignblog/2014/11/24/the-equal-sign

[#4 · Accepted solution]

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]

Thanks that's got it.

a decent solution