Excel to QlikViewTranspose Issue

[padmanabhan_ram]

Hi All,

I have a requirement of uploading an excel which has been attached here.

I am unable to have the similar format in QlikView.

Please advise with suggestions.

Many Thanks Advance,

Padmanabhan

[MK_QSL]

Exact Match is Not possible in QlikView .

But you can obviously use Pivot Table which can give you nearby result.

[padmanabhan_ram]

Can you plase help us with an example.

[Anonymous]

Please can you use cross table to load this excel to qlikview and use pivot table to display in the said format in excel

[its_anandrjs]

Hi,

You can load this excel as cross table and make some changes in excel if requires and use pivot table to display data and in some places you can use text box for this also.

Thanks & Regards

[padmanabhan_ram]

Cross Table Didn't work.

[Anonymous]

Try to remove functional attributes text , insert text columns and upload

[its_anandrjs]

Hi,

Yes right but if possible make changes in excel sheet like in

1.Colleague 1 to Colleague 5 below column you have to leave cells blank

2.In Competency column the data in excel is merge cell you have to un merge it and fill data in cell according to first row like Eg:- Copy 'Achievement Drive' for its related rows like ways you have to do for all indicator rows data.

and after making changes load data from excel and make qvd of the tables. See the below load script.

Functional_Attributes:

LOAD Competency,

     Indicator,

     F3 as Colleague1,

     F4 as Colleague2,

     F5 as Colleague3,

     F6 as Colleague4,

     F7 as Colleague5

FROM

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 42)),

Remove(Row, Pos(Top, 41)),

Remove(Row, Pos(Top, 40)),

Remove(Row, Pos(Top, 39)),

Remove(Row, Pos(Top, 38)),

Remove(Row, Pos(Top, 37)),

Remove(Row, Pos(Top, 36)),

Remove(Row, Pos(Top, 35)),

Remove(Row, Pos(Top, 34)),

Remove(Row, Pos(Top, 33)),

Remove(Row, Pos(Top, 32)),

Remove(Row, Pos(Top, 31)),

Remove(Row, Pos(Top, 30)),

Remove(Row, Pos(Top, 29)),

Remove(Row, Pos(Top, 28)),

Remove(Row, Pos(Top, 27))

));

Producer_Focussed_on_new_new_business:

LOAD Competency,

     Indicator,

     F3 as Colleague1,

     F4 as Colleague2,

     F5 as Colleague3,

     F6 as Colleague4,

     F7 as Colleague5

FROM

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 28)),

Remove(Row, Pos(Top, 27)),

Remove(Row, Pos(Top, 26)),

Remove(Row, Pos(Top, 25)),

Remove(Row, Pos(Top, 24)),

Remove(Row, Pos(Top, 23)),

Remove(Row, Pos(Top, 22)),

Remove(Row, Pos(Top, 21)),

Remove(Row, Pos(Top, 20)),

Remove(Row, Pos(Top, 19)),

Remove(Row, Pos(Top, 18)),

Remove(Row, Pos(Top, 17)),

Remove(Row, Pos(Top, 16)),

Remove(Row, Pos(Top, 15)),

Remove(Row, Pos(Top, 14)),

Remove(Row, Pos(Top, 13)),

Remove(Row, Pos(Top, 12)),

Remove(Row, Pos(Top, 11)),

Remove(Row, Pos(Top, 10)),

Remove(Row, Pos(Top, 9)),

Remove(Row, Pos(Top, 8)),

Remove(Row, Pos(Top, 7)),

Remove(Row, Pos(Top, 6)),

Remove(Row, Pos(Top, 5)),

Remove(Row, Pos(Top, 4)),

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 1))

));

Hope this helps

Thanks & Regards

[Anonymous]

Use text object to display text removed in excel sheet

desired location on pivot table

[padmanabhan_ram]

I am able to view a similar structure in Pivot Table. Thanks for that.

How can I present these Attributes and competencies in graph once the ratings are filled by collegues.