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: 
taylor_jesse
Creator
Creator

Text Box Header

Hi,

I have a text box as a header that displays the header on top of a straight table based on what the user selects.

For instance if the user selects a Team, the team name will appear.

I am trying to do the same thing for when a user selects a region as well as a group.

It works for when a user selects a region however when select a group, the two text boxes overlap.

Below are the expression for each text box

Expression for text box for Team header

=if(isnull(LocationDescription and Location_LocationCode),LocationDescription_LocationCode&' ' & group,' ')

Conditional expression to display the text box

=GetSelectedCount(TeamFilter)>0

Expression for text box for Region header

=region_name

Conditional expression to display the text box

=GetSelectedCount(region_name)>0 and (LocationDescription_LocationCode)<1

Expression for text box for group header

=group_name

Conditional expression to display the text box

=GetSelectedCount(group_name)>0

Attached is also how it looks when multiple is selected.

8 Replies
vishsaggi
Champion III
Champion III

Your image is not visible, can you re attach the image and also if possible share your qvw file where you have this issue?

taylor_jesse
Creator
Creator
Author

How do I share part of the document?

vishsaggi
Champion III
Champion III

I cannot see that image. You can save your qvw file with a different name and in that new qvw file delete sheets which are not necessary and just keep the sheet which has those two text objects and attach the file using Advanced editor.

taylor_jesse
Creator
Creator
Author

document don't seem to be loading when attached

vishsaggi
Champion III
Champion III

How big is your document? Are you getting any error?

taylor_jesse
Creator
Creator
Author

Its pretty big and I get an error that its not able to load when I attached it. It doesn't load on my local machine

vishsaggi
Champion III
Champion III

So just load only that data required by those text objects or create a sample data and your expected output. It will take little time but worth creating some sample from your original qvw file.

taylor_jesse
Creator
Creator
Author

Sounds good. I will do that and attach it