Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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