topic Re: PIE CHART in QlikView

PIE CHART

Tue, 14 Apr 2015 07:21:25 GMT

HI ALl,

I have to show a pie chart by count of members and coount of customers

the pie chart should give me percentage og customer and percentage of members

but there should not be any dimensions in it .

I Have already ploted a pie chart writng in expression as

count( Customers)

count( members )

But this is showing me pie chartlike 100% customers , the percentage is not being showed for mebers

What do i do ? can someone help me on this

PrashantSangle — Tue, 14 Apr 2015 07:33:22 GMT

Try with gauge chart

Regards

MK_QSL — Tue, 14 Apr 2015 07:39:40 GMT

COUNT Of Customers and Members with respect to what?

Have you tried Count(Customer)/COUNT(ALL Customer)?

danieloberbilli — Tue, 14 Apr 2015 07:44:23 GMT

Something like that...please find qvw attached

jagan — Tue, 14 Apr 2015 07:52:04 GMT

Hi,

Try like this

Calculated Dimension: ValueList('Customers', 'Members')

Expression : =If(ValueList('Customers', 'Members') = 'Customers', Count(Customers), Count(Members))

Regards,

Jagan.