Ranking multiple dimensions

[#1]

Hi there.

I've using Qlikview for two weeks and QSense for two more, so firstly I apologize if something results obvious.

The problem is as it follows:

I'm working on a dashboad that have been built from a poll in xlxs format (excel), so I'd like to represent several rankings.

For instance, we have some reasons for leaving the company as a client. That client could have chosen one or more reasons, and the reasons are collected in the excel file as columns. When I try to build up a bar chart, Sense considers each reason (column) as a dimenson, then I'm only able to represent one per chart and, of course, manually sorted. This is what I've got:

I've only reached to this partial solution, one bar chart per reason (A,B,C...) showed as a unique bar.

Any sugestion for impleting it as one complete chart, for dynamic sorting and so on?

Thank you so much for any help    : D

[#2]

Guess no chance on building this up :S

[amayuresh]

Provide post sample data in excel and clearly mention your requirement in details

[#4]

Perhaps:

[All_Data]:

LOAD

     ID,

     Col1,

     Col2,

     Col3

FROM [yourExcelFile];

LOAD

     ID,

     Col1 AS Reason

RESIDENT All_Data;

CONCATENATE

LOAD

     ID,

     Col2 AS Reason

RESIDENT All_Data;

CONCATENATE

LOAD

     ID,

     Col3 AS Reason

RESIDENT All_Data;

DROP TABLE All_Data;

[amayuresh]

Please load sample data not, script.

[#6 · Accepted solution]

Hi again.

Sorry for responding a bit late, but I had some other issues on the 'to do' pile.

Finally I could solved it using the function crosstable().

Thank you guyz.