topic Re: Set Analysis for Comparison in QlikView

Set Analysis for Comparison

nihhalmca — Mon, 26 Aug 2013 17:05:08 GMT

Hi All,

I need your assistance, i am facing one issue regarding "set analysis in pie chart" i.e

which product sold greater than 10,000 in 2012 and 2013

for instance,

Product Sales in2012 Sales in 2013

Dell 20000 16000

lenova 15000 10000

Acer 12000 8000

Sony 9000 6000

I need to know comparison in % on Pie Chart for 2012 and 2013

Thanks and Regards

Nihhal

Re: Set Analysis for Comparison

Mon, 26 Aug 2013 17:46:33 GMT

Hi,

See attached. Here's the set:

sum({<[Sales in 2013] = {'>10000'}>}[Sales in 2013]) +
sum({<[Sales in2012] = {'>10000'}>}[Sales in2012])

Best,

Matt

Re: Set Analysis for Comparison

nihhalmca — Tue, 27 Aug 2013 06:22:34 GMT

Hi matthew, Thanks for reply

My requirment is comaparison between 2012 and 2013 means pie chart want to show only 2012 and 2013 value is in %

like image

Regards,

Nihhal

Re: Set Analysis for Comparison

tresB — Tue, 27 Aug 2013 06:26:45 GMT

Expression tab- > Check 'Relative' and Check 'Values on Data Points'

Re: Set Analysis for Comparison

Tue, 27 Aug 2013 06:34:56 GMT

Hi,

If you want to compare 2012 with 2013 in the pie chart, don't sum both values. Put the 2013 data in one expression, and the 2012 data in another different expression (just the way matthew posted). Don't pick any dimension for the pie chart.

Re: Re: Set Analysis for Comparison

Tue, 27 Aug 2013 07:00:13 GMT

Hi Nihhal

Here with I have modified the object. Have a look and let me know.

-Jay

Re: Set Analysis for Comparison

nihhalmca — Tue, 27 Aug 2013 07:24:27 GMT

Hi tresesco

Pie chart want to show two values only one is which product sold >10000 and second is <10000 for 2012 as well as 2013 by clicking year, please see image

Re: Set Analysis for Comparison

nihhalmca — Tue, 27 Aug 2013 08:24:00 GMT

Hi jaya Thank you i got solution almost by your attachment please let me know how i display value(like % value) inside Pie Chart like my image

Re: Set Analysis for Comparison

jagan — Tue, 27 Aug 2013 08:27:33 GMT

Hi Nihhal,

It is not possible to display values inside pie. You can display outside the pie or in the legend. Hope this helps you.

Regards,

Jagan.

Re: Set Analysis for Comparison

Tue, 27 Aug 2013 08:31:45 GMT

The only way to achieve that is with an extension. Check out:

PieChart Visualization for Google BigQuery

Or using the Whisker Pie Chart extension, that is already installed in Qlikview.