topic Re: Dynamic Pie chart in QlikView

Dynamic Pie chart

msbhuvanesh003 — Wed, 04 Jul 2018 09:48:34 GMT

Hi all,

I want to show a pie chart based on my filter pane selection (using qlik sense).

Initially my chart will be 100% with 1 colour, as i select country from the filter pane the pie chart should automatically adjust based on the country i have selected.

Default Selection :

After selecting india from the filter pane the graph should look like this

If i added another country then

Can anyone please help me to achieve the same, if I remove the same also the graph should update.

Thanks

Nicil

Re: Dynamic Pie chart

Anil_Babu_Samineni — Wed, 04 Jul 2018 11:27:21 GMT

Please post sample QVW

Re: Dynamic Pie chart

msbhuvanesh003 — Wed, 04 Jul 2018 12:22:05 GMT

Hi Anil,

Thanks for the reply,

I have found one method,

=IF (WildMatch(GetFieldSelections(Country, ',', 100), '*' & Country& '*'), GetFieldSelections(Country, ',', 100), 'Rest Of Country')

If i give like this then all the countries are appended to the pie chart like bangladesh, india, australia.....

Is there any expressions we can use?

Thanks

Nicil

Re: Dynamic Pie chart

Anil_Babu_Samineni — Wed, 04 Jul 2018 13:29:14 GMT

Can you share QVW file, We are fine even Scramble data

Re: Dynamic Pie chart

BalaBhaskar_Qlik — Wed, 04 Jul 2018 14:00:33 GMT

On what basis, the share percentage of 2nd and 3rd pic are same for single & even for multiple countries.

Re: Dynamic Pie chart

msbhuvanesh003 — Wed, 04 Jul 2018 14:12:30 GMT

Please check the attached sample data

Re: Dynamic Pie chart

msbhuvanesh003 — Wed, 04 Jul 2018 14:13:12 GMT

I have attached an excel with the selection, can you please check

Re: Dynamic Pie chart

Anil_Babu_Samineni — Thu, 05 Jul 2018 14:06:50 GMT

Create Pie chart using below concept and check.

Dimension

=If(GetSelectedCount(Country)>1 and Match(Country,$(=Concat(Chr(39) & Country & Chr(39),','))),Country)

Expression

If(GetSelectedCount(Country)>1,Sum(Count),Sum(Count))

If(GetSelectedCount(Country)>1,Sum({<Country={$(=Concat(Chr(39) & Country & Chr(39),','))}>} Count),Sum(Count))

Re: Dynamic Pie chart

msbhuvanesh003 — Sun, 22 Jul 2018 11:33:00 GMT

Hi Anil,

Sorry for the late reply,

Its working but if we haven't selected any country, it shows as incomplete visualization.

Thanks

Re: Dynamic Pie chart

Anil_Babu_Samineni — Mon, 23 Jul 2018 13:55:59 GMT

Please check attachment and use dimension as below

=If(GetSelectedCount(Country)>1 and Match(Country,$(=Concat(Chr(39) & Country & Chr(39),','))),Country,Country)