pie to table

[soniasweety]

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

[felipedl]

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 Table	level_field dimension Table
Region	level_field
Country	Country
	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]

if there is  association between them   how can achieve this?

what is the process to get the output?

[felipedl · Accepted solution]

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]

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]

m

[felipedl]

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...