topic Re: Automatic Title Change? in QlikView

Automatic Title Change?

MuraliPrasath — Wed, 26 Aug 2015 07:06:49 GMT

Hi,

I've a show conditions buttons for pivot table.but based on the user's selection my title needs be shown.

For example: If the user selected the MML and RXV then title needs to show MML & RXV together.

Re: Automatic Title Change?

Chanty4u — Wed, 26 Aug 2015 07:12:13 GMT

Hi ,

Create an html file and give that link path in actions..

hope this helps you

Thank you

Suresh

Re: Automatic Title Change?

Anders_Eriksson — Wed, 26 Aug 2015 07:21:49 GMT

Don't see a problem here?

I guess your buttons sets variables that you use in show conditions for the expressions in the table.

Use calculated titles and the same variables and it should be easy.

Re: Automatic Title Change?

Anonymous — Wed, 26 Aug 2015 07:32:39 GMT

can you post your title of your Pivot table

how to you Combine the button into title?

Re: Automatic Title Change?

jagan — Wed, 26 Aug 2015 07:52:49 GMT

Hi,

Give this below expression in Title

=vMML & ' & ' & vRXV & ' & ' & vICL & ' & ' & vBBB & ' & ' & vTotal

Replace vMML, vRXV, vICL, vBBB and vTotal with your actual variable names.

Hope this helps you.

Regards,

Jagan.

Re: Automatic Title Change?

MuraliPrasath — Wed, 26 Aug 2015 08:41:41 GMT

Hi Jagan,

Here is my title code.

=vShowMML & ' & ' & vShowRXV & ' & ' & vShowICL & ' & ' & vShowBBB & ' & ' & vShowTotal

but the title output shows like this now.

1 & 0 & 0 & 0 & 0

Re: Automatic Title Change?

jagan — Wed, 26 Aug 2015 08:59:06 GMT

Hi,

Instead of setting 1 & 0 you can set MML & blank space, RXV & blank space etc. If you attach sample file then it would be easier to understand.

Regards,

Jagan.

Re: Automatic Title Change?

Anders_Eriksson — Wed, 26 Aug 2015 09:10:39 GMT

This will do it;

= Replace(Replace(if(vShowMML, 'MML§') & if(vShowRXV, '§RXV§') & if(vShowICL, '§ICL§') & if(vShowBBB, '§BBB§') & if(vShowTotal, '§Total'), '§§', ' & '), '§', '') & ' Schedule'

Re: Automatic Title Change?

MuraliPrasath — Wed, 26 Aug 2015 09:44:23 GMT

thanks Jagan.

Finally I'm using the below one to show the selected button title on Pivot table..

=if(vShowMML,'MML')&' '& if(vShowRXV,'RXV') &' '& if(vShowICL,'ICL') &' '& if(vShowBBB,'BBB') &' '& if(vShowTotal,'Total')

Re: Automatic Title Change?

jagan — Wed, 26 Aug 2015 09:53:32 GMT

Good, you catched the logic.

Regards,

Jagan.