topic Common header in QlikView

Common header

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

Is there any way to show a common header "CustomerID" above customer id values (ALKFI,ANTAR,AROUT,BERGS).

Currently it is displayed on left Side.

Re: Common header

pamaxeed — Wed, 27 Dec 2017 18:22:13 GMT

What you could do is to create a Dummy Dimension which groups all the values (ALFKI, ANATR...) and add it in the chart (hide dimension labels) and apply color format. But it is a kind of hack.

With standard Qlikview pivot table it is not possible to achieve it.

Re: Common header

devarasu07 — Wed, 27 Dec 2017 18:47:48 GMT

Hi,

try below methods

Method 1:

using Calculated dimension

=if(match(CustomerID,'ALFKI','ANATR','AROUT','BERGS'),'CustomerID')

Method 2: using synthetic dimension option

=valuelist('CustomerID')

Method 3: if you using more than one chart object better to go with data island back end script option/master dimension (sense)

Thanks,

Deva

Re: Common header

Venkatchoudary — Wed, 27 Dec 2017 22:16:15 GMT

Not Sure it may usefull or not, but create custom text box and hover over on chart next to Output

Re: Common header

martinpohl — Thu, 28 Dec 2017 18:07:28 GMT

Qlik is not Excel!

It's a look and feel if you are using straight tables and pivot tables.

A better way to compare values is Charts. Use the power of visual charts.