Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

using comments from dbase

Hello,

HOW DO I CODE THIS PROCEDURE SUCH THAT WHEN A USER CLICK ON AN INCIDENCE HE SEES THE COMMENTS OF THAT PARTICULAR INCIDENCE ON THE TEXTBOX BY THE RIGHT

AND WHEN INCIDENCE IS NOT CHECKED IT DISPLAYS NOTHING.

RGDS

EMA

1 Solution

Accepted Solutions
oscar_ortiz
Partner
Partner

Here's the solution.

View solution in original post

11 Replies
m_woolf
Master II
Master II

Put =COMMENTS in the textbox.

QlikView will display "-" if there is no comment or is there is more than 1 comment.

Not applicable
Author

I feel you didnt understand the question. plz find attached.

Thanks

m_woolf
Master II
Master II

Did you try my suggestion?

oscar_ortiz
Partner
Partner

Try using the following expression in the Layout tab under Show Conditional

Count ( DISTINCT INCIDENCE ) = 1

Also, under the General tab include =COMMENTS.

Good luck,

Oscar

Not applicable
Author

I did Micheal

Not applicable
Author

@Oscar this isnt wat i want. find attached

oscar_ortiz
Partner
Partner

Here's the solution.

View solution in original post

Not applicable
Author

cant we set the empty water incidence to become "No comment"?

oscar_ortiz
Partner
Partner

Sure, modify the text object expression to be:

If( IsNull(COMMENTS), 'No Comment', COMMENTS)