PIE CHART QUERY

[gowtham08]

Hi All,

I have a doubt regarding Pie chart. My data contains two columns, "Country" and "Licence". The value in the licence field are "NA", "VALID" and "EXPIRED" for different countries in the Country column. I'm trying to do a pie chart to show only Valid and Expired dimensions for the country count. I also want to show the figure in percentage without decimal points. I'm struggling to do it as I'm only getting the following pie chart and I could not remove the dimension "NA" and also I have problem with rounding of the percentage.

Could anybody help me please?

[Raphael_Sabbagh]

Hi.

To get rid of NA, put : Count({<LICENCE=-{'NA'}>} COUNTRY) as measure.

But for rounding the percentage, I didn't find any solution in my Qlik Sense instance (I'm running on September 2020)