Common header

[Anonymous]

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.

[pamaxeed]

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.

[devarasu07]

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

[Venkatchoudary]

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

[martinpohl]

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.