Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can we have one column for manual writing text in QV object

Dear All,

I hope you all are doing great and enhancing Qlik View expertise time to time.

Kindly advise the solution for below query.

Is there any feature in qlik view that we can insert some comments in QV object.

In my organisation we are doing data quality check for different countries and client wants to have one column where one can manually enter comments according to the figures in table.

We do not want those comments to be added in the database just want to extract that table with comments as separate excel file.

1 Solution

Accepted Solutions
Not applicable
Author

Hi Nikhil,

Please find the attached QVW.

View solution in original post

15 Replies
avinashelite

I don't think this is possible in Qlikview, try with input box option once.

avinashelite

Not applicable
Author

I tried that but i don't think it will work here.

Is there any other way out to have solution for such scenario.

avinashelite

one way is , you can capture the comments in an excel and load the same or try with this threads once

Free Text Box Extension Object

Dynamic Update - Simple Database

Not applicable
Author

Hi,

You can do this by using 'Inputfield' command of qlikview. Just declare a field using inputfield and load emptystring into that field at script level.You can use that field to enter your comments in front end.

syntax could be:

inputfield A;

load '' as A,

.......

.......

Not applicable
Author

Could you please explain a bit as could not understand how and where to use this syntax;

For example I have below scripting; where i want one table with city and percentage and one more column for comments to be given based on the figures.

Table:

LOAD State,

     City,

     Percentage

    

   

FROM

[Maps Info.xlsx]

(ooxml, embedded labels, table is Sheet1);

vardhancse
Specialist III
Specialist III

Hi,

In total we have 3 options:

  1. 1.    Web viewer extension object to show external SharePoint list.
    1. a. By this external object we can see the SharePoint directly in the dashboard as an object, where user can add the comments in SharePoint list.
    2. b. Platform team was not ready to install in server due to some performance issues

  1. 2.    Dynamic data update(Preferred)
    1. a. We need to enable in both document & server level.
    2. b. Once enabled also we need to add the users to qlikview administrator group(Waiting for response from Saini).

  1. 3.    QlikView SQL write back functionality.
    1. a. Where here also we need to use extension object which platform team was not ready to install any extension.
buzzy996
Master II
Master II

if this is ur major query "Is there any feature in qlik view that we can insert some comments in QV object."

u can try with, From Accesspoint report--Right click on ur chart--clik on Notes---Addnotes.

it helps,wht ur looking for

Not applicable
Author

My query is quite simple ,

Lets take an example

If i have one table with some sales data and i need one another column where i can write manually comments in each row like we usually do it in Excel file.

To accomplish this you can suggest any other way out also....

By the way what is Accesspoint report.