Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 - Specialist
Partner - Specialist

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 - Specialist
Partner - Specialist

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 - Specialist
Partner - Specialist

Here's the solution.

Not applicable
Author

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

oscar_ortiz
Partner - Specialist
Partner - Specialist

Sure, modify the text object expression to be:

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