Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Title Over Expressions

Hi,

Does anybody knows a way to put titles over groups of expressions in a pivot table like the attached image?Pivot Table - title.png

10 Replies

Re: Title Over Expressions

There is a trick, you have to define another dummy dimension (with load inline) and use it before your real dim.

Let me know

Employee
Employee

Re: Title Over Expressions

Alessandro Saccone solutions works well if you have same expresions for each value "Leitos"/"Paciente Dia", etc

Not applicable

Re: Title Over Expressions

Hi, Alessandro!

Can you show me how to do this?

Here is my qvw.

Re: Title Over Expressions

Sorry Fernando but I cannot download anything because my company policy ...

Not applicable

Re: Title Over Expressions

Clever, do you know a way to do this?

Re: Title Over Expressions

Load * inline [

myDim

Description_To_Add

];

Now, in every table where there is one of the field Leitos, Paciente, Ocupation add for each value the value

Description_To_Add.

The result must be:

... myDim, Leitos, Paciente, Ocupation

Description_To_Add, val1, val2, val3

Description_To_Add, val6, val5, val9

....

At this point using myDim as dimension you will see Description_To_Add as description and other fields below

Employee
Employee

Re: Title Over Expressions

If you have same expressions for each group, Saccone post is the answer

Employee
Employee

Re: Title Over Expressions

Fernando

Anexei a sugestão do Saccone

Not applicable

Re: Title Over Expressions

Clever,

Obrigado, mas verifiquei que os título aparecem em todas as expressões.

A intenção é aparecer assim como na imagem que anexei no primeiro post

Community Browser