Pie chart Expression

krishna20 — Mon, 11 Aug 2014 07:20:17 GMT

Hi Friends,

I'm little bit confusing with pie chart expression.

my Query in SQL is

SELECT SUM(DECODE(TP_BUS_SOURCE, 'D', TP_PREM_LC_1, 0)) ONLINE_PREM,

SUM(DECODE(TP_BUS_SOURCE, 'A', TP_PREM_LC_1, 0)) AGENT_PREM,

SUM(DECODE(TP_BUS_SOURCE, 'M', TP_PREM_LC_1, 0)) MOBILE_PREM,

SUM(DECODE(TP_BUS_SOURCE, 'K', TP_PREM_LC_1, 0)) KIOSK_PREM,

SUM(DECODE(TP_BUS_SOURCE, 'D',0, 'A', 0, 'K', 0, 'M', 0, TP_PREM_LC_1)) EMP_PREM

FROM T_GI_POLICY

i made it as two expressions in qlikview

1.sum({<TP_BUS_SOURCE={'*'}-{'A','D','K','M'}>}TP_PREM_LC_1).It shows the values for EPM_Prem.

I need to show the values for A ,M,K, D..How can i write in set analysis to show both in Piechart.

i tried like this

2.=sum({<TP_BUS_SOURCE={A},TP_BUS_SOURCE={A},TP_BUS_SOURCE={M},TP_BUS_SOURCE={K}>}TP_PREM_LC_1)

if i applied single conditional set analysis.its working.But, 1st expression values are turning to zero.When i promote the first expression its working and second expression values are turning to zero.

Can anyone please suggest me how to do it.

Thanks and Regards

Krishna

topic Pie chart Expression in QlikView

Pie chart Expression