topic Re: Expression in QlikView

Expression

upaliwije — Mon, 26 Jun 2017 09:33:02 GMT

Hi Friends

In my QV document I have a straight table where the Expression for Calculated Premium field does not show results as shown below

I have attached my document. Pls advise me to correct my error

Re: Expression

prma7799 — Mon, 26 Jun 2017 09:42:55 GMT

Please try like

=if (Aggr(IF(MaxString({<[BCOD]=P([BCOD])>}[BCOD])=[BCOD],[BCOD]),[BCOD])=BCOD,

(num(if (Aggr(IF(MaxString({<[BCOD]=P([BCOD])>}[BCOD])=[BCOD],[BCOD]),[BCOD])=BCOD, sum(PREMIUM)),'##,##0')

if (Aggr(sum({$<CC_CODE={'CC*'}>}PREMIUM),BCOD)>0,Aggr(sum({$<CC_CODE={'CC*'}>}PREMIUM),BCOD),0)

),sum(PREMIUM))

Re: Expression

Anonymous — Mon, 26 Jun 2017 09:45:21 GMT

Can you tell us what is it that you want to be displayed in the last column?

Re: Expression

Anil_Babu_Samineni — Mon, 26 Jun 2017 09:46:34 GMT

As always, try to ignore direct field names. And use Simple aggregation Sum() for your data point.

Re: Expression

Anonymous — Mon, 26 Jun 2017 09:47:41 GMT

This seems to be the correct answer you are looking for...

if (Aggr(IF(MaxString({<[BCOD]=P([BCOD])>}[BCOD])=[BCOD],[BCOD]),[BCOD])=BCOD,
(num(if (Aggr(IF(MaxString({<[BCOD]=P([BCOD])>}[BCOD])=[BCOD],[BCOD]),[BCOD])=BCOD, sum(PREMIUM)),'##,##0')
-
if (Aggr(sum({$<CC_CODE={'CC*'}>}sum(PREMIUM)),BCOD)>0,Aggr(sum({$<CC_CODE={'CC*'}>}sum(PREMIUM)),BCOD),0)
),sum(PREMIUM))

Re: Expression

Anonymous — Mon, 26 Jun 2017 11:14:21 GMT

Please close this thread if your problem is solved

Re: Expression

prma7799 — Mon, 26 Jun 2017 11:15:17 GMT

Already Closed ...

Re: Expression

upaliwije — Mon, 26 Jun 2017 11:17:31 GMT

already closed