Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
soniasweety
Valued Contributor III

pie to table

Hi all,

I have  a geo field   with  EMEA,APAC,NA   as a listbox

and I have a  pie chart with other dimension   level_Field

Dim: level_Field

primary

secondary

tertiary

measure:count(sales)

so my requirement is:  if I select  EMEA region   in pie chart it will show count of each level

so  If I select that level  In below I need the table with that count details

for example my result is 10 ,   that 10  details I need in a table

Tags (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: pie to table

AS a sample script, could be somtehing like this

Region:

Load * inline

[

Region, Country

    EMEA,Albania

    EMEA,Algeria

    EMEA,Andorra

    EMEA,South Africa

    EMEA,Spain

    EMEA,Sudan

    EMEA,Swaziland

    EMEA,Sweden

    EMEA,Switzerland

    EMEA,Syria

    EMEA,Tanzania

    EMEA,Togo

    EMEA,Tunisia

    EMEA,Turkey

    EMEA,Uganda

    EMEA,Ukraine

    EMEA,United Arab Emirates

    EMEA,United Kingdom

    EMEA,Vatican City

    EMEA,Western Sahara

    EMEA,Yemen

    EMEA,Zambia

    EPAC,Brunei

    EPAC,Laos

    EPAC,Myanmar

];

Level_Field:

Load * inline

[

Country,Sales,Level

    Myanmar,10,Primary

    Myanmar,10,Secondary

    Zambia,100,Terciary

    Zambia,1,Primary

    Algeria,50,Primary

];

See the attached qvf file for dash example

6 Replies
Partner
Partner

Re: pie to table

Hi Sony,

You would need to have some association between the region and the level_field dimensions.

Could be in distinct tables, but one association is needed.

Something like:

   

Region Tablelevel_field dimension Table
Regionlevel_field
CountryCountry
Number of sales

So this two tables would be connected by Country field, and you could make a selection on Region (EMEA, APAC,NA) and it would be associated on the other table by the countries.

So the pie chart would have the sales by level_field and the table by region.

Felipe.

soniasweety
Valued Contributor III

Re: pie to table

if there is  association between them   how can achieve this?

what is the process to get the output?

Partner
Partner

Re: pie to table

AS a sample script, could be somtehing like this

Region:

Load * inline

[

Region, Country

    EMEA,Albania

    EMEA,Algeria

    EMEA,Andorra

    EMEA,South Africa

    EMEA,Spain

    EMEA,Sudan

    EMEA,Swaziland

    EMEA,Sweden

    EMEA,Switzerland

    EMEA,Syria

    EMEA,Tanzania

    EMEA,Togo

    EMEA,Tunisia

    EMEA,Turkey

    EMEA,Uganda

    EMEA,Ukraine

    EMEA,United Arab Emirates

    EMEA,United Kingdom

    EMEA,Vatican City

    EMEA,Western Sahara

    EMEA,Yemen

    EMEA,Zambia

    EPAC,Brunei

    EPAC,Laos

    EPAC,Myanmar

];

Level_Field:

Load * inline

[

Country,Sales,Level

    Myanmar,10,Primary

    Myanmar,10,Secondary

    Zambia,100,Terciary

    Zambia,1,Primary

    Algeria,50,Primary

];

See the attached qvf file for dash example

soniasweety
Valued Contributor III

Re: pie to table

thanks,

changed according to my req.

but I need drill down in single dimenstion

like

I have GEO--- if I clik that it should dropdown that particular geo values like that

soniasweety
Valued Contributor III

Re: pie to table

m

Partner
Partner

Re: pie to table

Hi Sony,

See the attached link on how to make a drill-down dimension from Qlik Help:

http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Dimensions/create-drill-down-d...