topic Expression Issue in QlikView

Expression Issue

noman212 — Mon, 27 Jul 2015 06:14:27 GMT

i have the following expression but its shows no value against this expression.

Please find attachment,

Formula to Calculate Annaulized Premium is given below

Annualized Premium=if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))

Expression which i want to Display in atext Object:

= 'Rank 1 : '& CHR(10) &

'Client Name - '& FirstSortedValue(Clientname, -Aggr(SUM(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))),Clientname)) & CHR(10) &

'Proposal - '& FirstSortedValue(Proposal, -Aggr(SUM(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))),Clientname)) & CHR(10) &

'Annual Premium - '& FirstSortedValue(Aggr(SUM(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))),Clientname), -Aggr(SUM(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))),Clientname)) & CHR(10) &

'Risk - '& FirstSortedValue(Aggr(SUM(sumatrisk),Clientname), -Aggr(SUM(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))),Clientname)) & CHR(10) &

'Consultant Name - '& FirstSortedValue(ConsultantName, -Aggr(SUM(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))),Clientname)) & CHR(10) &

'Branch Name - '& FirstSortedValue(BranchName, -Aggr(SUM(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))),Clientname))

Re: Expression Issue

sushil353 — Mon, 27 Jul 2015 06:27:14 GMT

Hi,

Try if this works for you

= 'Rank 1 : '& CHR(10) &

'Client Name - '& Concat(FirstSortedValue(Clientname, -Aggr(SUM(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly))))),Clientname)),',')

Re: Expression Issue

noman212 — Mon, 27 Jul 2015 06:39:25 GMT

Nope, Error in Expression

Re: Expression Issue

noman212 — Tue, 28 Jul 2015 10:38:50 GMT

= 'Rank 1 : '& CHR(10) &

'Client Name - '& FirstSortedValue(Clientname, -AGGR(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly)))),Clientname)) & CHR(10) &

'Proposal - '& FirstSortedValue(Proposal, -AGGR(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly)))),Clientname)) & CHR(10) &

'Annual Premium - '& FirstSortedValue(AGGR(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly)))),Clientname), -AGGR(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly)))),Clientname)) & CHR(10) &

'Risk - '& FirstSortedValue(Aggr(SUM(sumatrisk),Clientname), -AGGR(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly)))),Clientname)) & CHR(10) &

'Consultant Name - '& FirstSortedValue(ConsultantName, -AGGR(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly)))),Clientname)) & CHR(10) &

'Branch Name - '& FirstSortedValue(BranchName, -AGGR(if(ModeType='A',sum({$<statuscode={'13'}>} Annual),if(ModeType='H',sum({$<statuscode={'13'}>} Half),if(ModeType='Q',sum({$<statuscode={'13'}>} Quar),sum({$<statuscode={'13'}>} Monthly)))),Clientname))