topic Re: Pie chart in QlikView

Pie chart

ashokraju — Wed, 25 Nov 2020 16:16:04 GMT

I have a scenario.I have a dimension like Duplicate number.In that dimension values are 1,1,1,2,2,2,2,2,2,3,3,3,3,3 like that.

I want to create a pie chart '1' is repeated two times i want to show one duplicate.'1' is repeated three times i want to show two duplicates like that for 2 and 3 also.

How i do this in pie chart.please suggest me.

Re: Pie chart

m_woolf — Mon, 03 Oct 2016 19:59:41 GMT

See the attached qvw:

Re: Pie chart

jagan — Tue, 04 Oct 2016 05:59:00 GMT

Hi,

Try like this

Dimension: DimensionName

Expression: Count(DimensionName)

Regards,

jagan.

Re: Pie chart

nagarjuna_kotha — Tue, 04 Oct 2016 06:13:03 GMT

I m not getting what exactly ur output?

Can u provide output like

1- ?

2- ?

3- ?

-Nagarjun

Re: Pie chart

nagarjuna_kotha — Tue, 04 Oct 2016 06:16:48 GMT

If want count of unique values thn take

Dimension: DimensionName

Expression: Count(Distinct Value)

Output:

1- 1

2- 1

3- 1

If u want count actual values

Dimension: DimensionName

Expression: Count(Value)

Output:

1- 3

2- 6

3- 5

-Nagarjun

Re: Pie chart

Anonymous — Tue, 04 Oct 2016 06:44:46 GMT

Add your value as Dimension and add expression as Count(yourValue)

Re: Pie chart

sampada0810 — Tue, 04 Oct 2016 10:33:40 GMT

add you dimension as value and expression as Count of Distinct values.

Re: Pie chart

Anonymous — Tue, 04 Oct 2016 10:58:13 GMT

hi,

use below expression , so that one show no of repeated values in the list

=if (aggr(NODISTINCT count(values))>1,1,0)

regards,

Gireesh