Merge two columns from same table into one column with their corresponding values

[rohansoni649]

Hi,

I have a table which contains columns like Dealer No., Dealer Name, Model, Zone and their corresponding values(Throughput). The data is related to car services.

Let's suppose, I add a column "Dealer No." in a straight table and the throughput values and now I want to show the column "Zone" below "Dealer No." with the corresponding values(Throughput values) against "Zone".

Region Name is Zone actually.

So above all the pivot table and I want to append both so that Dealer and Region Name get append into one single column with their corresponding values date wise.

I want to send Nprinting reports to the user. I can't even hide the headers in QlikView or Nprinting pivot tables.

Output:

[stevedark]

Hi @rohansoni649 

What you need to have in this case is all of those values in the same dimension, and have that dimension associate with the appropriate values in the source table.

Assuming that each Dealer can only belong in one Region you could do this after the existing load. This assumes you have a table called Throughput.

PivotDim:
LOAD DISTINCT
   Dual('Dealer', 1) as DimType,
   Dealer,
   Dealer as PivotDim
RESIDENT Throughput;

CONCATENATE(PivotDim)
LOAD DISTINCT
   Dual('Region', 2) as DimType,
   Dealer,
   Region as PivotDim
RESIDENT Throughput;

You can then use PivotDim as the dimension in the pivot and sort that dimension by DimType. Each dealer will link to itself in the new table, and each region will link to every dealer in that region.

There is a blog post I've written about this kind of technique which goes into more detail, should you want a longer read:
https://www.quickintelligence.co.uk/qlikview-accumulate-values/

Hope that helps,
Steve

[vinieme12]

"I want to send Nprinting reports to the user. I can't even hide the headers in QlikView or Nprinting pivot tables."

you have the option to hide table header >> add the tables as objects and not as images

places the  object tags on below the other

<object1>   <---- With title enabled

<object2>   <---- With title disabled

Or you can create a single table using an additional dimension

create in inline table as below

Load * inline [

TableDim

1

2

];

in chart use below expression as Dimension

=Pick(TableDim,Dealer,RegionName)