topic using comments from dbase in QlikView

using comments from dbase

Mon, 24 Nov 2014 17:24:03 GMT

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

Re: using comments from dbase

m_woolf — Mon, 24 Nov 2014 18:32:03 GMT

Put =COMMENTS in the textbox.

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

Re: using comments from dbase

Mon, 24 Nov 2014 19:28:50 GMT

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

Thanks

Re: using comments from dbase

m_woolf — Mon, 24 Nov 2014 19:31:53 GMT

Did you try my suggestion?

Re: using comments from dbase

oscar_ortiz — Mon, 24 Nov 2014 19:45:09 GMT

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

Re: using comments from dbase

Mon, 24 Nov 2014 20:01:58 GMT

I did Micheal

Re: using comments from dbase

Mon, 24 Nov 2014 20:04:03 GMT

@Oscar this isnt wat i want. find attached

Re: Re: using comments from dbase

oscar_ortiz — Mon, 24 Nov 2014 20:04:56 GMT

Here's the solution.

Re: using comments from dbase

Mon, 24 Nov 2014 20:22:10 GMT

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

Re: using comments from dbase

oscar_ortiz — Mon, 24 Nov 2014 20:26:13 GMT

Sure, modify the text object expression to be:

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

Re: using comments from dbase

oscar_ortiz — Mon, 24 Nov 2014 20:35:05 GMT

Did this not take care of the issue? I noticed you marked as helpful but not complete.

Re: using comments from dbase

Mon, 24 Nov 2014 21:14:23 GMT

You can use below expression in Text box:

if(getselectedcount(INCIDENCE)=1,Concat(COMMENTS,';'),'Nothing')