Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
ramanannad
New Contributor III

Append variable into dimension

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):

NameSales
MrA100
MrB101
MrC

102

frontend Variable(achieved thru an input box extension):

VariableValue
vTstnameMrD

Expected Output :

NameSales
MrA100
MrB101
MrC

102

MrD-

Or just ignoring the measure, we just need :

Name
MrA
MrB
MrC
MrD

Hope you guys any an idea about this, cheers

Ram

2 Replies

Re: Append variable into dimension

Try this?

LOAD * Inline [

Name, Sales

MrA, 100

MrB, 101

MrC, 102

];

Concatenate

LOAD * Inline [

Name

'$(Variable)'

];

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
effinty2112
Honored Contributor

Re: Append variable into dimension

Hi Ramanan,

Try this calculated dimension

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

Cheers

Andrew