Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Creating an input box, altering data

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

3 Replies
Not applicable

Re: Creating an input box, altering data

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

Not applicable

Creating an input box, altering data

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.

Not applicable

Re: Creating an input box, altering data

nd

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

    4, 2

];

And look at the image for the object.

C u,

Stefano.

Community Browser