Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Karim_Khan
Creator III
Creator III

input box taking values not expression

Hi Team,

   I am trying to import all variables from one application and exporting it to another application.But here am getting the values of expression in input box inspite of expression code which i have written in Variable overwiew window

Variables:

LOAD Variable,

    Expression

FROM

[...\List_Of_Variables.xls]

(biff, embedded labels, table is Sheet1$);

Let vNumberOfRows = NoOfRows('Variables');

For vI = 0 to (vNumberOfRows - 1)

Let vVariable_Name = Peek('Variable',vI,'Expression');

Let [$(vVariable_Name)] = Peek('Expression',vI,'Expression');

Next

for e.g i have written my expression in variable overview window as below

vDivideNum

=If(Display_Number=1,1,

  If(Display_Number=2,100000,

  If(Display_Number=3,1000000,

  If(Display_Number=4,10000000)

  )

  )

)

but in input box its taking as

vDivideNum = -

Reagrds,

Karim Khan

KK
5 Replies
vishsaggi
Champion III
Champion III

What are you expecting to see in your input box vDivideNum? IF you select a value from from Display_Number listbox it will show the value right?

Karim_Khan
Creator III
Creator III
Author

‌it’s taking value only bt I wanted to take expression is there any other alternative other than input box to pull all variables

KK
vishsaggi
Champion III
Champion III

Sorry can you elaborate a little please. Can you tell us what you are expecting to see?

trdandamudi
Master II
Master II

See if the below link is going to help:

export variables and its content to text file

Karim_Khan
Creator III
Creator III
Author

No it's not full filling my requirment

KK