topic Creating an input box, altering data in QlikView

Creating an input box, altering data

Mon, 03 Oct 2011 09:08:32 GMT

Hi!

I hope I managed to place this discussion thread in the proper place. It's kind of like a maze when you're new here.

I do have a beginners question to QV regarding Input Boxes. I have example data containing Sales Rep, Store, Region and sales sum. At the moment I'd like to create an input box to alter data; say for example I want to changed a sales rep's sales summary from 10,000 to 100,000.

Also; is it possible too use the input box as a "search" function, say you want all sales over 10,000 (>= 10000)?

I've tried searching around but I can't really located a detailed enough help. I've also reviewed the tutorial that is supplied but it doesn't really answer my question.

Thanks in advance,

asolsson

Re: Creating an input box, altering data

Mon, 03 Oct 2011 09:35:05 GMT

Hi,

u have to use an input field.

Look at my example, i put a bookmark also to select sales over than a value.

I hope this helps you.

C u,

Stefano

Creating an input box, altering data

Mon, 03 Oct 2011 09:57:30 GMT

Oh dang, I'm using the Personal Edition (I believe that is what it's called) so it tells me I can't open this file.

Re: Creating an input box, altering data

Mon, 03 Oct 2011 10:02:50 GMT

Ok, this is the script:

INPUTFIELD val;

tab:

load*,rowno() as key;

LOAD * INLINE [

cli, val

1, 10

1, 20

2, 43

3, 3

4, 2

];

And look at the image for the object.

C u,

Stefano.