Write a note as a user

[#1]

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

/ Jessica

[brenner_martina]

Hi,

see attached example

[#3]

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;

-----------

[#4]

Hi

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;

SQLSQL

SQL

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

SELECT

[#5]

Maybe this can be a option

[#6]

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

[#7]

Where is the table that comments are saved to?

[rwunderlich]

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

[#9]

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?

[rwunderlich]

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