topic Re: Merging columns in Table/Pivot table in QlikView

Merging columns in Table/Pivot table

Tue, 24 Mar 2015 14:14:22 GMT

Hi Friends,

Is it possible to make a table box or pivot chart like as shown below

If yes, can you please help how to do it.

Thanks in advance.

Regards,

Kuldeep

Tue, 24 Mar 2015 14:18:37 GMT

I can't see the table.

Tue, 24 Mar 2015 14:24:02 GMT

Wed, 25 Mar 2015 10:17:56 GMT

Try this Example

Wed, 25 Mar 2015 11:31:58 GMT

This was in an excel file, just wanted to check whether we can create something like this in Qlikview as well.

Regards,

Kuldeep

Wed, 25 Mar 2015 11:38:47 GMT

hi Kuldeep

You can try this

By Using Joins function in the qlikview

Wed, 25 Mar 2015 11:46:13 GMT

Hi,

may be you can achieve it by using pivot table,

just adjust batting bowling as per your need & achieve total by show partial sum of Team..

murugesh — Thu, 30 May 2019 14:13:28 GMT

I could not able to view your Merge two columns expression could you send me it