topic Re: Input Box for Where Clause in QlikView

Input Box for Where Clause

gerhardl — Tue, 19 Mar 2013 09:56:51 GMT

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,

MayilVahanan — Tue, 19 Mar 2013 10:08:24 GMT

PFA

hope it helps

gerhardl — Tue, 19 Mar 2013 10:09:58 GMT

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 — Tue, 19 Mar 2013 10:12:52 GMT

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