Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to set the memo in the QV.

For example,

Rawdata:

LOAD * INLINE [

Institution, Distributor,Sales

A101,B101,500

A101,B102,700

A102,B101,600

B101,C102,350

B101,D103,200

A103,C102,600

......

];

table A in the QV,

InstitutionTotal SalesMemo
A1011200[user input]:it's high
A102600
A103600
B101550[user input]:it's lower,please notice
.........

I want to create a column "Memo" to let users input their notice information.

Because the "Memo" is not set on unique row in Rawdata, I think inputfield function is unuseful to do it.

And I want to create an other table in the script like following:

Memo:

Replace only

LOAD Institution,

          Memo

FROM

(txt, codepage is 936, embedded labels, delimiter is ',', no quotes);

then the running process like:

1) user input the Memo in input-box

2) write to TXT file by Macro

3) run Partial Reload by Macro to read the Memo

Is it realizable?

0 Replies