Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
As an addition: NOT a comments field external of the table, I know how to do that. Thanks!
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, '. ')
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?
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
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.
What I try to do is to enter either A B C etc in the comments field
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.