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
