Calculated column in Pivot table

Fri, 29 Mar 2013 07:31:23 GMT

Hi all,

[Submissions]=== sum(if(wildmatch(POLICY_SYMBOL,'MAC', 'PAC', 'GLP', 'CPP') and [Receive Date] >= $(StartDate) and [Receive Date] <=$(EndDate),1,0))

[Declined=== sum(if(wildmatch(POLICY_SYMBOL,'MAC', 'PAC', 'GLP', 'CPP') and DECLINED_DT >= $(StartDate) and DECLINED_DT <=$(EndDate) and SUBMISSION_STATUS='DECLINED',1,0))

In the pviot table submission and declined are calucalted expressions.

I want to caluclate thrid expression like below,so please help me to convert this expression to qlikview expression.

Declined to Submitted=if ([Submissions]= 0.0 )then (0.0)else ([Declined] / [Submissions])

Re: Calculated column in Pivot table

manideep78 — Fri, 29 Mar 2013 08:41:12 GMT

If(Submissions = 0.0 ,'0.0',Declined/Submissions)

topic Calculated column in Pivot table in QlikView

Calculated column in Pivot table

Re: Calculated column in Pivot table