Additional Heading

[#1]

Hi,

I have attached table on qlikview (As Is table) but I want to add heading on each two or three colomns (To Be Table). Any help please?

[its_anandrjs]

Hi,

You have to use labels for this will be better.

Hope this helps

Thanks & Regards

[Carlos_Reyes]

Other than adding your labes as dimensions in your data... the most you can do is to use ValueList as in the attached example.

I don't know how to hide the unwanted expressions for each label.

[#4]

Sorry could you please explain step by step that how can I use labels. e.g. I have three colomns called Colomn 1, Colomn 2 and Colomn 3. I want main heading of three Colomns called All Colomns. How should I get it using labels.

[#5]

Hi Carlos,

I can't open qvw file as using personal edition. Could you please explain step by step

[Carlos_Reyes]

Hi,

I'll explain my example since it'll be difficult to make sense without your data.

• Create a new file
• Go to the Script Editor and paste this code:

LOAD * INLINE [
Country, Sales
Canada, 456321
USA, 761234
Mexico, 231476
Ecuador, 982356
Colombia, 123212
Brasil, 453287
Uruguay, 679243
Chile, 543211
UK, 447231
];

• Reload the app.
• Create a pivot table with Country as first dimension
• Create a calculated dimension as second dimension with the following code.

=ValueList('Group1','Group2','Group3')

• Create the first expression with the following code:

Pick(Match(ValueList('Group1','Group2','Group3'),'Group1','Group2','Group3')
  ,sum(Sales)
)

• Create a second expression with this code:

Pick(Match(ValueList('Group1','Group2','Group3'),'Group1','Group2','Group3')
  ,0
  ,sum( {$<Country={'Canada','USA','Mexico'}>} Sales)
)

• Create a third expression with the next code:

Pick(Match(ValueList('Group1','Group2','Group3'),'Group1','Group2','Group3')
  ,0
  ,0
  ,sum( {$<Country={'Chile','Colombia','Ecuador'}>} Sales)
)

• Expand all dimensions and drag the second (calculated) dimension so that appears above the expressions line.
• Review the differences for each expression to understand why each one shows different results.

Hope this helps!

[#7]

Hi Carlos,

Thanks but I have already created table. Any simple soltion?

[its_anandrjs]

Hi,

Create a label and give heading like Branch and give properties as Layout -> Top like make 2 labels also and give text decisioned and Fulfilment and place over the chart.

It is not good idea but it works some time.

Hope this helps

Thanks & Regards