topic Re: Text Box Header in QlikView

Text Box Header

taylor_jesse — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Text Box Header

vishsaggi — Thu, 28 Jun 2018 19:42:40 GMT

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

Re: Text Box Header

taylor_jesse — Thu, 28 Jun 2018 19:50:24 GMT

How do I share part of the document?

Re: Text Box Header

vishsaggi — Thu, 28 Jun 2018 19:59:58 GMT

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.

Re: Text Box Header

taylor_jesse — Thu, 28 Jun 2018 20:24:11 GMT

document don't seem to be loading when attached

Re: Text Box Header

vishsaggi — Thu, 28 Jun 2018 20:31:29 GMT

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

Re: Text Box Header

taylor_jesse — Thu, 28 Jun 2018 20:34:14 GMT

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

Re: Text Box Header

vishsaggi — Thu, 28 Jun 2018 20:37:43 GMT

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.

Re: Text Box Header

taylor_jesse — Thu, 28 Jun 2018 20:39:29 GMT

Sounds good. I will do that and attach it