Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokraju
Contributor II
Contributor II

Pie chart

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.

7 Replies
m_woolf
Master II
Master II

See the attached qvw:

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Dimension: DimensionName

Expression: Count(DimensionName)

Regards,

jagan.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

I m not getting what exactly ur output?

Can u provide output like

1- ?

2- ?

3- ?

-Nagarjun

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

rgvavihs
Specialist
Specialist

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

sampada0810
Creator
Creator

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

gireesh007
Contributor III
Contributor III

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