Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
You have to use labels for this will be better.
Hope this helps
Thanks & Regards
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.
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.
Hi Carlos,
I can't open qvw file as using personal edition. Could you please explain step by step
Hi,
I'll explain my example since it'll be difficult to make sense without your data.
LOAD * INLINE [
Country, Sales
Canada, 456321
USA, 761234
Mexico, 231476
Ecuador, 982356
Colombia, 123212
Brasil, 453287
Uruguay, 679243
Chile, 543211
UK, 447231
];
=ValueList('Group1','Group2','Group3')
Pick(Match(ValueList('Group1','Group2','Group3'),'Group1','Group2','Group3')
,sum(Sales)
)
Pick(Match(ValueList('Group1','Group2','Group3'),'Group1','Group2','Group3')
,0
,sum( {$<Country={'Canada','USA','Mexico'}>} Sales)
)
Pick(Match(ValueList('Group1','Group2','Group3'),'Group1','Group2','Group3')
,0
,0
,sum( {$<Country={'Chile','Colombia','Ecuador'}>} Sales)
)
Hope this helps!
Hi Carlos,
Thanks but I have already created table. Any simple soltion?
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