topic Inputfields and charts not working? in QlikView

Inputfields and charts not working?

Fri, 17 Sep 2010 11:43:53 GMT

Hi all,

The manual states:

Values of an input field can be changed in list box cells, table box cells and in table
chart expression cells.

But although its fine in list boxes and table boxes it doesnt seem to work on either pivot or straight table charts in v9sr4 - is this a bug or am I missing something?

Regards,

Gordon

Inputfields and charts not working?

disqr_rm — Fri, 17 Sep 2010 12:11:35 GMT

How does your expression looks? InputSum?

Inputfields and charts not working?

Fri, 17 Sep 2010 12:31:02 GMT

Hi Rakesh,

No, my expression definition is simply the field name. Is this the wrong way to use an inputfield and if so how would it be used in that case?

Regards,

Gordon

Inputfields and charts not working?

disqr_rm — Fri, 17 Sep 2010 12:38:46 GMT

That's the problem. Try putting InputSum(YourKeyFigureField) for Sum and InputAvg() for Average functions. Check help on these two functions and you will see what needs to be done.

The listbox and tableboxes do not need the aggregation function, but charts do.

Hope this help you.

Regards, Rakesh

Inputfields and charts not working?

Fri, 17 Sep 2010 13:04:22 GMT

I see. The problem I have is that these are text fields. I am using a chart rather than a table box as I create a calculated dimension to only show rows where an 'input allowed' flag is set (by using an 'if' in the calculated dimension then suppress when null).

Any thoughts, Rakesh?

Gordon