topic Write a note as a user in QlikView

Write a note as a user

Wed, 20 Oct 2010 13:54:05 GMT

How can our user write notes in a field in an application? Heard that this should be possible.

/ Jessica

Write a note as a user

Wed, 20 Oct 2010 14:35:06 GMT

check out InputField in Qlikview,

/Daniel

Write a note as a user

Wed, 20 Oct 2010 14:44:58 GMT

Please be more exact. Where do I find InputField?

/ Jessica

Write a note as a user

johnw — Wed, 20 Oct 2010 23:26:04 GMT


JessicaG wrote:Please be more exact. Where do I find InputField?

You could search for it in the reference manual or in the help text. Another way to write notes might be with a variable in an input box. Neither seems like a particularly good solution. QlikView isn't good for jotting down notes.

Write a note as a user

pover — Thu, 21 Oct 2010 05:44:02 GMT

The inputfield is good if the note has to be associated with a field. You can also write notes when you make a bookmark, and if you are using the QV Server Enterprise Edition, users can create their own text objects where they can write notes. They can keep these notes to themselves or share with other users.

Regards.

Write a note as a user

Thu, 21 Oct 2010 09:40:37 GMT

This is exactly what I was looking for, that users can create their own text objects where they can write notes and share with other users. But how do we do that?

/Jessica

Write a note as a user

pover — Fri, 22 Oct 2010 00:51:42 GMT

Jessica,

If you're using the IE Plugin to view the QlikView reports, right-click on a blank space of the QlikView and select "New Sheet Object->Text Object...". In the AJAX client you do the same right-click and select New Sheet Object. The small window will appear and you then drag the Text Object icon (the one that has a 'A').

If you don't see this option, you probably don't have the QV Server Enterprise Edition. Confirm with your provider.

Regards.

Write a note as a user

Mon, 21 Mar 2011 12:50:08 GMT

Hi i fail to understand how a text box object can be used for user input?

Im also looking at the options available to get user notes entry. I have used the variable input box but this is limited to one line.

Please explain how the text box objectcan be used??

AW:Re: Write a note as a user

brenner_martina — Mon, 21 Mar 2011 12:59:49 GMT

Hi,

do you need an entry for every data record? Than you can use

INPUTFIELD Remark;

in the script and enter in the resp. table

Load ID, Field, ...
'' As Remark
From Table;

that means, that every record gets a new field for input.

Then create a straight table with ID, Fieldlist and Remark. A blue box with an arrow to left appears in the Remark Column. Now every user can enter their own jotting.

If you wnat to save the entries, you can export them and reload with next script reload.

AW:Re: Write a note as a user

Tue, 22 Mar 2011 16:02:54 GMT

Hi, would eb good to see a working example?

AW:Re: AW:Re: Write a note as a user

brenner_martina — Tue, 22 Mar 2011 16:19:05 GMT

Hi,

see attached example

AW:Re: AW:Re: Write a note as a user

Tue, 22 Mar 2011 16:30:17 GMT

Many thanks for the example.

I noticed your code has qvx. Is this some kind of temporary qlikview table? I know qvd and qvw and that it.

-------

Left Join (Data)
Load *,
Sales As Forecast,
'' As Comment
Resident Data;

Store Data Into Data.qvx;

-----------

AW:Re: Write a note as a user

Wed, 23 Mar 2011 08:59:42 GMT

If a part of my script looks like this and I want that every user can enter their own jotting after every calcid how do I enter your example in my script then?

LEFT

KEEP (SALESTABLE) LOAD CALCID as key1

CALCNAME

CUSTNAME

CUSTACCOUNT

CONTACTPERSONID

INVOICEACCOUNT

OFFERPRICE

GBASESALES

TOTALCOST

FIXEDCOST

WAGECOST

DIRECTCOST

//PAPERCOST,

SALESORDERDATE

SALESORDER

ITEMID

DATAAREAID;

//RecVersion;

SQL

*FROM "DynamicsAx_Prod".dbo.GCALCTABLE WHERE dataareaid = 'msp';

SELECT

Write a note as a user

Wed, 23 Mar 2011 09:52:53 GMT

Maybe this can be a option

Re: Write a note as a user

Tue, 08 Jul 2014 18:43:33 GMT

Does this save comments or changes to the field on both the table and the enterprise level?

Re: Write a note as a user

Tue, 08 Jul 2014 18:43:52 GMT

Where is the table that comments are saved to?

Re: Write a note as a user

rwunderlich — Tue, 08 Jul 2014 18:46:30 GMT

Note that this is a very old thread. If you are looking to have users write notes, check out the Annotations feature of V11.

-Rob

Re: Write a note as a user

Tue, 08 Jul 2014 19:28:53 GMT

Hey Rob,

Does the annotations allow changes in the field or comments added by the user to be seen in the datatables as well as online?

Re: Write a note as a user

rwunderlich — Tue, 08 Jul 2014 20:56:09 GMT

Annotations are kept in a separate file on the server. They are not written to any qlikview data table or back to a database.

Annotations are attached to a screen object and they are visible to all users.

-Rob