How to draw a Horizontal Chart

[#1]

Hi everyone.

I've loaded the following table in Sense:

Customer code	Country	Region	City	Revenues
000011090	Italy	Lombardy	Milan	750,000
000011967	Italy	Sicily	Palermo	450,000

What I'd like to do is to show the above-mentioned table in the following way inside a sheet:

Filter box: Customer code. Let's say, I select 000011090.

Customer code selection
000011090

Then,

Fields	Value
Customer code	000011090
Country	Italy
Region	Lombardy
City	Milan
Revenues	750,000

Is it possible to do that?

Thanks.

[Anonymous]

Hi,

Direct functionality is not available i guess, need to check extensions for this.

[#3]

Thanks for your answer. Can you please recommend some extensions then?

I've tried simple chart (or something like that, can't remember the exact name right now) but it wasn't able to do the job.

[rahulpawarb]

Hello Gabriele,

Please refer below given sample script:

Data:
CrossTable(Fields, Value, 1)
LOAD [Customer code] AS Filter,
    [Customer code],
    Country,
    Region,
    City,
    Revenues
FROM
[https://community.qlik.com/thread/267829?sr=stream&ru=249060]
(html, codepage is 1252, embedded labels, table is @1);

P.S.: Please use Filter field into Filter Box.

Regards!

Rahul