topic Re: Title Over Expressions in QlikView https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774580#M535178 <HTML><HEAD></HEAD><BODY><P>Load * inline [</P><P>myDim</P><P>Description_To_Add</P><P>];</P><P>Now, in every table where there is one of the field Leitos, Paciente, Ocupation add for each value the value</P><P>Description_To_Add.</P><P></P><P>The result must be:</P><P>... myDim, Leitos, Paciente, Ocupation</P><P> Description_To_Add, val1, val2, val3</P><P> Description_To_Add, val6, val5, val9</P><P>....</P><P></P><P>At this point using myDim as dimension you will see Description_To_Add as description and other fields below</P></BODY></HTML> Mon, 12 Jan 2015 16:41:48 GMT alexandros17 2015-01-12T16:41:48Z Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774574#M535172 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Does anybody knows a way to put titles over groups of expressions in a pivot table like the attached image?<IMG alt="Pivot Table - title.png" class="image-1 jive-image" src="/legacyfs/online/75140_Pivot Table - title.png" style="height: 477px; width: 620px;" /></P></BODY></HTML> Mon, 12 Jan 2015 15:57:07 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774574#M535172 2015-01-12T15:57:07Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774575#M535173 <HTML><HEAD></HEAD><BODY><P>There is a trick, you have to define another dummy dimension (with load inline) and use it before your real dim.</P><P></P><P>Let me know</P></BODY></HTML> Mon, 12 Jan 2015 16:07:30 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774575#M535173 alexandros17 2015-01-12T16:07:30Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774576#M535174 <HTML><HEAD></HEAD><BODY><P>Alessandro Saccone solutions works well if you have same expresions for each value "Leitos"/"Paciente Dia", etc</P></BODY></HTML> Mon, 12 Jan 2015 16:15:34 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774576#M535174 Clever_Anjos 2015-01-12T16:15:34Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774577#M535175 <HTML><HEAD></HEAD><BODY><P>Hi, Alessandro!</P><P></P><P>Can you show me how to do this?</P><P>Here is my qvw.</P></BODY></HTML> Mon, 12 Jan 2015 16:17:00 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774577#M535175 2015-01-12T16:17:00Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774578#M535176 <HTML><HEAD></HEAD><BODY><P>Sorry Fernando but I cannot download anything because my company policy ...</P></BODY></HTML> Mon, 12 Jan 2015 16:30:54 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774578#M535176 alexandros17 2015-01-12T16:30:54Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774579#M535177 <HTML><HEAD></HEAD><BODY><P>Clever, do you know a way to do this?</P></BODY></HTML> Mon, 12 Jan 2015 16:33:57 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774579#M535177 2015-01-12T16:33:57Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774580#M535178 <HTML><HEAD></HEAD><BODY><P>Load * inline [</P><P>myDim</P><P>Description_To_Add</P><P>];</P><P>Now, in every table where there is one of the field Leitos, Paciente, Ocupation add for each value the value</P><P>Description_To_Add.</P><P></P><P>The result must be:</P><P>... myDim, Leitos, Paciente, Ocupation</P><P> Description_To_Add, val1, val2, val3</P><P> Description_To_Add, val6, val5, val9</P><P>....</P><P></P><P>At this point using myDim as dimension you will see Description_To_Add as description and other fields below</P></BODY></HTML> Mon, 12 Jan 2015 16:41:48 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774580#M535178 alexandros17 2015-01-12T16:41:48Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774581#M535179 <HTML><HEAD></HEAD><BODY><P>If you have same expressions for each group, Saccone post is the answer</P></BODY></HTML> Mon, 12 Jan 2015 16:59:57 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774581#M535179 Clever_Anjos 2015-01-12T16:59:57Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774582#M535180 <HTML><HEAD></HEAD><BODY><P>Fernando</P><P>Anexei a sugestão do Saccone</P></BODY></HTML> Mon, 12 Jan 2015 17:21:07 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774582#M535180 Clever_Anjos 2015-01-12T17:21:07Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774583#M535181 <HTML><HEAD></HEAD><BODY><P>Clever,</P><P>Obrigado, mas verifiquei que os título aparecem em todas as expressões.</P><P>A intenção é aparecer assim como na imagem que anexei no primeiro post</P></BODY></HTML> Mon, 12 Jan 2015 17:26:03 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774583#M535181 2015-01-12T17:26:03Z Re: Title Over Expressions https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774584#M535182 <HTML><HEAD></HEAD><BODY><P>Foi o que imaginei...</P><P>Infelizmente não é possível ainda, teria que incluir alguns text box (sujeitando-se a problemas de posicionamento quando o usuário mexer na tabela)</P></BODY></HTML> Mon, 12 Jan 2015 17:29:59 GMT https://community.qlik.com/t5/QlikView/Title-Over-Expressions/m-p/774584#M535182 Clever_Anjos 2015-01-12T17:29:59Z