topic Pie chart question in QlikView

Pie chart question

Mon, 30 Jun 2014 15:39:43 GMT

I have a value for computer warranty expiration dates and with a value like that all the dates are different. However in the pie chart I would like it to breakdown the warranty expiration for the years. So it will display a value for x number in 2015 and x number in 2016. Then if you choose to click on a slice of the pie in the table box it shows all the machines that are due in that year. Possible? Thanks!

Re: Pie chart question

Nicole-Smith — Mon, 30 Jun 2014 15:52:49 GMT

First Dimension: year(yearstart(YourDateField))

Condition: GetSelectedCount(YourDateField)=0

Second Dimension: YourDateField

Condition: GetSelectedCount(YourDateField)>0

Re: Pie chart question

Mon, 30 Jun 2014 15:54:40 GMT

You can try the concept of creating groups which on click of slice shows the sub-dimension values.

Thanks,

Sai

Re: Pie chart question

Mon, 30 Jun 2014 18:38:10 GMT

Thanks!

Re: Pie chart question

Tue, 01 Jul 2014 15:44:24 GMT

I got the items in but I don't think it is calculating correctly because when I pull the same data into a pivot table my counts are different. Is this what should be seen?

Re: Pie chart question

Nicole-Smith — Tue, 01 Jul 2014 16:01:18 GMT

Looks right to me. As long as you're using the same dimensions and expression in the pivot table, I don't see why they would be any different.