using comments from dbase

[#1]

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

[m_woolf]

Put =COMMENTS in the textbox.

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

[#3]

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

Thanks

[m_woolf]

Did you try my suggestion?

[oscar_ortiz]

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

[#6]

I did Micheal

[#7]

@Oscar this isnt wat i want. find attached

[oscar_ortiz · Accepted solution]

Here's the solution.

[#9]

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

[oscar_ortiz]

Sure, modify the text object expression to be:

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