Pie chart Expression

[krishna20]

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