topic Re: Merge two columns from same table into one column with their corresponding values in App Development

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

rohansoni649 — Fri, 15 Nov 2024 21:03:10 GMT

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:

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

stevedark — Sun, 25 Feb 2024 09:21:25 GMT

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

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

vinieme12 — Mon, 26 Feb 2024 08:15:58 GMT

"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

];

in chart use below expression as Dimension

=Pick(TableDim,Dealer,RegionName)