Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can our user write notes in a field in an application? Heard that this should be possible.
/ Jessica
Hi,
see attached example
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;
-----------
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;
SQLSQLSQL
*FROM "DynamicsAx_Prod".dbo.GCALCTABLE WHERE dataareaid = 'msp';
SELECTMaybe this can be a option
Does this save comments or changes to the field on both the table and the enterprise level?
Where is the table that comments are saved to?
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
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?
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