topic Re: Append variable into dimension in QlikView

Append variable into dimension

ramanannad — Thu, 28 Sep 2017 02:11:32 GMT

Hi Experts,

Have an inquiry on how do we append a value from a front-end variable into a loaded field from data source ?

Visualization :

Source table(excel file):

frontend Variable(achieved thru an input box extension):

Variable	Value
vTstname	MrD

Expected Output :

Or just ignoring the measure, we just need :

Hope you guys any an idea about this, cheers

Ram

Anil_Babu_Samineni — Thu, 28 Sep 2017 05:04:33 GMT

Try this?

LOAD * Inline [

Name, Sales

MrA, 100

MrB, 101

MrC, 102

];

Concatenate

LOAD * Inline [

Name

'$(Variable)'

];

effinty2112 — Thu, 28 Sep 2017 07:47:26 GMT

Hi Ramanan,

Try this calculated dimension

=Name & if(isnull(Name),vTstname)

Cheers

Andrew