Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Direct functionality is not available i guess, need to check extensions for this.
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.
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