topic Re: Making Pivot from different files with same column in QlikView

Making Pivot from different files with same column

bhuprakash — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

Could you please help me to get the data in below format because when I am loading the data then it is adding the counts at one place but I need it country wise. I have separate file for all countries and there is no column of country in file.

Re: Making Pivot from different files with same column

Anil_Babu_Samineni — Sat, 06 Jan 2018 15:57:51 GMT

We can make calc. Dimension but not really sure how you want to split each

ValueList('Indonesia', 'Malaysia', 'Philippines', 'Vietnam')

Re: Making Pivot from different files with same column

devarasu07 — Sat, 06 Jan 2018 16:19:28 GMT

Hi,

we can build the report we need to excel source file, but u can also try to add country and concatenate them as one fact refer below script.

create pivot table chart,

dimension

[Current State]

Country

(after adding try to enable check box for "always fully expanded" chart property presentation tab and country field u have to transpose Country from row to column )

Measure:

=Count([Lead Code])

Fact:
//IndonesiaDemoFarm:
LOAD 'Indonesia' as Country,
[Lead Code],
    [Assigned To],
    [User ID],
    [Creation Date],
    [Current State]
FROM 
(ooxml, embedded labels, table is [Indonesia DemoFarm]);
Concatenate
//MalaysiaDemoFarm:
LOAD 'Malaysia' as Country,
[Lead Code],
    [Assigned To],
    [User ID],
    [Creation Date],
    [Current State]
FROM

(ooxml, embedded labels, table is [Malaysia Demo Farm]);
Concatenate
//PhilippinesDemofarm:
LOAD Country,
    [Lead Code],
    [Assigned To],
    [User ID],
    [Creation Date],
    [Current State]
FROM

(ooxml, embedded labels, table is [Philippines Demofarm]);
Concatenate
//VietnamDemoFarm:
LOAD
'Vietnam' as Country,
[Lead Code],
    [Assigned To],
    [User ID],
    [Creation Date],
    [Current State]
FROM

(ooxml, embedded labels, table is [Vietnam DemoFarm]);

Re: Making Pivot from different files with same column

bhuprakash — Sat, 06 Jan 2018 17:06:13 GMT

Thanks a lot Devarasu and Anil. It is working perfectly.

Re: Making Pivot from different files with same column

devarasu07 — Sat, 06 Jan 2018 17:07:09 GMT

Hi,

Close this thread by marking as helpful and correct. thanks

Re: Making Pivot from different files with same column

bhuprakash — Sat, 06 Jan 2018 17:09:55 GMT

Dear, Only Helpfull is coming in list. Correct Answer is not coming.