Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
Highlighted
Not applicable

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

Hi Nikhil,

Please find the attached QVW.

View solution in original post

15 Replies
Highlighted

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

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

Highlighted

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

Highlighted
Not applicable

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

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

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

Highlighted

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

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

Highlighted
Not applicable

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

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,

.......

.......

Highlighted
Not applicable

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

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);

Highlighted
vardhancse
Valued Contributor III

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

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.
Highlighted
buzzy996
Honored Contributor II

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

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

Highlighted
Not applicable

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

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.