topic Inputfield Comments in Pivot in QlikView

Inputfield Comments in Pivot

Wed, 29 Feb 2012 16:04:01 GMT

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!!

Inputfield Comments in Pivot

Wed, 29 Feb 2012 16:08:17 GMT

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

Inputfield Comments in Pivot

Wed, 29 Feb 2012 16:15:38 GMT

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

inputfield comments;

'' 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, '. ')

Inputfield Comments in Pivot

Wed, 29 Feb 2012 16:23:29 GMT

Hi Matt,

tried several variances:

"AS Comments

" 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?

Re: Inputfield Comments in Pivot

Wed, 29 Feb 2012 16:25:59 GMT

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

Inputfield Comments in Pivot

Wed, 29 Feb 2012 16:33:41 GMT

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.

Inputfield Comments in Pivot

Wed, 29 Feb 2012 16:35:39 GMT

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

Re: Inputfield Comments in Pivot

Wed, 29 Feb 2012 19:05:23 GMT

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.