topic Re: Need column in table where you can input values like in a spreadsheet in QlikView

Need column in table where you can input values like in a spreadsheet

Thu, 23 Jun 2011 16:16:51 GMT

I am wondering if it is possible to make an object with "spreadsheet functionality".

For example, we make a straight table with one dimension "Name". Values are David and Kim. I would like to add an expression, maybe with all blank values called "Customizable Notes". However, I would like to be able to click inside a cell in that Notes column of the table and ENTER MY OWN NOTE. So for David, I would want to enter the note "Must get back to him about Action Items" and have that show up in the chart.

I can't think of any way this would be possible. I'm wondering if anyone has a clever workaround? Also, would this be possible as an Extension Object? (which I know little about)??

Any thoughts are appreciated. I know this isn't what Qlikview is used for. Thanks so much!

Scott

Re: Need column in table where you can input values like in a spreadsheet

matt_crowther — Thu, 23 Jun 2011 16:25:09 GMT

Attached.

Add an export macro for the table followed by a reload and you can 'fix' the input values - or indeed pass them back to another datasource.

Hope that helps,

Matt - Visual Analytics Ltd

Re: Need column in table where you can input values like in a spreadsheet

Thu, 23 Jun 2011 21:30:37 GMT

Matt, that's a really nice example. Unfortunately, I cannot understand it as I have limited experience with macros and the comments are not in English. Could you help explain what you did?

Thanks.

Re: Need column in table where you can input values like in a spreadsheet

Thu, 23 Jun 2011 21:38:03 GMT

Actually, I got it now. Thanks a lot. This is really neat!

Re: Need column in table where you can input values like in a spreadsheet

Fri, 08 Jul 2011 20:57:59 GMT

Twist!

Looks like if you reload your own doc in SR3 the INPUTFIELD functionality breaks. Qlikview has this to say on the topic:

"Inputfields are not compatible with joins or resident loads.

The reason for this is that an inputfield must be read one time and one time only. Once

the inputfield is read it is added to an inputfield table and this table cannot be

tampered with. Joins affect the table and for that reason inputfields are disabled when

combined with joins. Resident works slightly different but it also affects the inputfield

table and it is disabled for the same reason."

This was partly addressed in this discussion: http://community.qlik.com/message/129738#129738

Does anyone have a workaround for this? The basic functionality that you can see if you download Matt's document seems valuable, and it wouldn't make sense to me to lose it.

Re: Need column in table where you can input values like in a spreadsheet

Mon, 11 Feb 2013 16:57:00 GMT

its great...

I have Version 9.0

I have a issue using the input field in pivot..it doesnt store the values in pivot but it does in table box.Could someone help me?

thanks for your help

INPUTFIELD

Comments;

SHIP_DETAILS:

LOAD

HSONUM

as SONUM,

HSHPNO

as SHPNO,

HSHIPID

as HSHIPID,

date

(SHIPDAT,'M/D/YYYY') as SHIPDAT,

SHIPVIA

as SHIPVIA,

SHIPFRT

as SHIPFRT,

date

(SHIPENT,'M/D/YYYY') as SHIPENT,

date

(SHIPENT,'M/D/YYYY') as Cal_Date,

SHIPPO

as SHIPPO

FROM

\OG\QVD\PAI_CHD_SHIPFIL.qvd (qvd);

// Adding Comments as Input Field

Left

Join(SHIP_DETAILS)

Load

as Comments

Resident

SHIP_DETAILS;

Store

SHIP_DETAILS into SHIP_DETAILS.qvd;

//drop table SHIP_DETAILS;