Input Box for Where Clause

[gerhardl]

Hi There,

Might be a dumb question.

I often want to pull in data for testing purposes, using a where statement at the end of my load script.

e.g

LOAD Field1,

Field2,

Field3

FROM [here]

WHERE Field2  = '12345'

For instance, I would pull in all the transactions for one specific account.

Is there any way to click on relaod, and then have QLikvIew give me an input box where I can input the value I want it to use in the Where statement?

So it will come up like an input box will, and I'll paste the account number and it will load only the account's transactions?

I never use input boxes, so this might be very obvious.

Thanks,

G

[MayilVahanan]

Hi

PFA

hope it helps

[gerhardl]

Sorry I always forget to say: I have QV Prsonal Edition so can't open your file.

Can you maybe send an image of the script, or paste the text here?

[MayilVahanan · Accepted solution]

Hi

Let vInout = Input('','Please enter');

Load * Inline

[

Field1,Field2,Field3

1,2,3

1,3,4

2,3,4

]where Field2 = $(vInout);

give 2 or 3 in input box

hope it helps