Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text box properties

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
Not applicable
Author

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

nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi,

Try this expression

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

Use Same syntax for nested if.

Regards,

Nirav Bhimani

Not applicable
Author

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