Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ali_hijazi
Honored Contributor

input inside a cell?

Hello

Is there a way to put an input object inside a cell of a pivot table or straight table?

I need it so that the user puts a value in this input on the pivot table and a third column is calculated based on the value entered by the user

1 Solution

Accepted Solutions
deepakk
Valued Contributor III

Re: input inside a cell?

hi,

I hope the attach application helps you out.

Deepak

5 Replies
Not applicable

input inside a cell?

As far as i know you cannot do it for one cell of the pivot table, since i have tried to use the combination of 'Input sum' and 'Sum' in one expression, though it doesnt help to make the functionality up and running.

One idea, cant we do this with Inputbox?

- Sridhar

ali_hijazi
Honored Contributor

input inside a cell?

with input box then the desired column's value of all rows will be affected

I want only the selected row's desired column to be affected

Not applicable

input inside a cell?

If i understand you properly, you want more than one row to be affected by the input value.

Cant we use If statment to do this with combination of varaible, like this

sum(if (WildMatch(Field1,'A','C','D'), Variable*Field2,Field2))

If this is not solving your purpose, please post the sample with your required o/p.

-Sridhar

ali_hijazi
Honored Contributor

input inside a cell?

Well I have a pivot table with the salesmen names as dimension

in the expressions I have 3 columns A, B, and C

the data for A is read from database

Now the values of column C is the result of subtracting the value of B -A

values of column B are input by user

so suppose in some row in the pivot table the value of A is 500 and the user inputs 250 in the cell of B then automatically value of C in the same row is 250-500 = -250

can we accomplish this?

it is like in Excel!!

deepakk
Valued Contributor III

Re: input inside a cell?

hi,

I hope the attach application helps you out.

Deepak