topic Re: Additional Heading in QlikView

Additional Heading

Thu, 13 Mar 2014 14:18:56 GMT

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?

Re: Additional Heading

its_anandrjs — Thu, 13 Mar 2014 15:19:37 GMT

Hi,

You have to use labels for this will be better.

Hope this helps

Thanks & Regards

Re: Additional Heading

Carlos_Reyes — Thu, 13 Mar 2014 15:27:48 GMT

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.

Re: Additional Heading

Thu, 13 Mar 2014 15:30:41 GMT

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.

Re: Additional Heading

Thu, 13 Mar 2014 15:32:53 GMT

Hi Carlos,

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

Re: Re: Additional Heading

Carlos_Reyes — Thu, 13 Mar 2014 15:42:55 GMT

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!

Re: Re: Additional Heading

Thu, 13 Mar 2014 15:59:01 GMT

Hi Carlos,

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

Re: Re: Additional Heading

its_anandrjs — Thu, 13 Mar 2014 16:05:50 GMT

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