topic Re: input box taking values not expression in QlikView

input box taking values not expression

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

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');

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

Re: input box taking values not expression

vishsaggi — Thu, 09 Aug 2018 15:54:29 GMT

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?

Re: input box taking values not expression

Karim_Khan — Thu, 09 Aug 2018 16:01:02 GMT

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

Re: input box taking values not expression

vishsaggi — Thu, 09 Aug 2018 16:03:06 GMT

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

Re: input box taking values not expression

trdandamudi — Thu, 09 Aug 2018 16:18:27 GMT

See if the below link is going to help:

export variables and its content to text file

Re: input box taking values not expression

Karim_Khan — Fri, 10 Aug 2018 06:08:41 GMT

No it's not full filling my requirment