Inputfield Comments in Pivot

[#1]

Hi Guys,

I hope you can help me with this:

I would like to add a comment column to my pivot table but I really have no clue how to do that. My script looks like this:

LOAD Country,
Brand,
Perspective,
[Value Driver],
[Definition KPI],
[KPI Formula],
[Definition in words],
[Year Value 2011],
[Budget/ Target Value],
FC,
FY,
delta,
[Group Target],
[KPI Type],
[Level of fulfiment of local targets],
[Level of fulfilment BP of 15],
Fulfilment,
[choosen target]

FROM
;

This is not working, already tried it. So how can I insert an input field into a pivot table that is preverably not loaded over the script?

Thanks for any ideas!!

[#2]

As an addition: NOT a comments field external of the table, I know how to do that. Thanks!

[#3]

Your input field needs to be tied to your data for it to display in your table. Try this,

inputfield comments;

LOAD Country,
Brand,
Perspective,
[Value Driver],
[Definition KPI],
[KPI Formula],
[Definition in words],
[Year Value 2011],
[Budget/ Target Value],
FC,
FY,
delta,
[Group Target],
[KPI Type],
[Level of fulfiment of local targets],
[Level of fulfilment BP of 15],
Fulfilment,
[choosen target],

'' AS comments

FROM
[d:\Dokumente und Einstellungen\.;. ......)

You may need to use an aggregation of the comments in your pivot table. You can do that using the concat function in the expression like this:

concat(comments, '. ')

[#4]

Hi Matt,

tried several variances:

"AS Comments

A

B

C"

" AS Comments [...]"

"[AS Comments .....]"

but neither worked. The problem is I don't know the language for QV, do you have an idea what I could use insteand of as to adress the inputfield?

[#5]

The quotes are 2 apostrophes rather than a set of double quotes. You are simply initially setting the comments field to a zero length string. You could instead have:

'comments here' AS comments

[#6]

Hi,

ok that works, thanks a lot!

But how do I insert it as an inputfield? concat is not working how you described it.

I'm sorry I'm really new in working with QV.

[#7]

What I try to do is to enter either A B C etc in the comments field

[#8]

Sorry, my mistake, you can't use concat() in a table and it oporate as an input field. You can only use inputsum() and inputavg() for numerical values so they won't work for comments in a pivot table.

You can only add them to a listbox or straight table.