Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Actually, I got it now. Thanks a lot. This is really neat!
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.
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
CM
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;