Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to draw a Horizontal Chart

Hi everyone.

I've loaded the following table in Sense:

Customer codeCountryRegionCityRevenues
000011090ItalyLombardyMilan

750,000

000011967ItalySicilyPalermo450,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,

FieldsValue
Customer code000011090
CountryItaly
RegionLombardy
CityMilan
Revenues

750,000

Is it possible to do that?

Thanks.

Tags (3)
3 Replies
sadasiva
Contributor

Re: How to draw a Horizontal Chart

Hi,

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

Not applicable

Re: How to draw a Horizontal Chart

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
Valued Contributor II

Re: How to draw a Horizontal Chart

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