topic Text box properties in QlikView

Text box properties

Wed, 13 Mar 2013 05:54:50 GMT

Hi,

am having a list box which contains 8 categoreis like actor,jamesbond,car,director,writer etc. If i select jamesbond then "4% of people who talk positive about movie say that Skyfall is best bond movie" the quoted text should appear in textbox similarly if i select actor then "4% of people say that Silva reminds them of Joker from “The Dark Knight”." this text shud appear. For remaining categories text box should not appear. This is the problem statement am having.

Am trying with getselectedcount(category)=jamesbond in the layout of text box but its not working well.

Regards,

Tejavardhan

Re: Text box properties

Wed, 13 Mar 2013 10:37:58 GMT

Hello Teja,

You can try using :

=if(Category = 'jamesbond','4% of people who talk positive about movie say that Skyfall is best bond movie',

if(Category = 'actor','4% of people say that Silva reminds them of Joker from “The Dark Knight','Else condition'))

let me know if this was the actual requirement.

thanks,

itsangad

Re: Text box properties

nirav_bhimani — Wed, 13 Mar 2013 10:41:52 GMT

Hi,

Try this expression

if(GetFieldSelections(Category) = 'jamesbond ', 'Message',0)

Use Same syntax for nested if.

Regards,

Nirav Bhimani

Re: Text box properties

Wed, 13 Mar 2013 10:55:06 GMT

Hi,

Use previously mentioned in the TEXT of text box and

=if(GetFieldSelections(Category) = 'jamesbond',1,0) + if(GetFieldSelections(Category) = 'actor',1,0)

this at Show Condition in the Layout.

thanks,

itsangad