Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Summary level data giving wrong result

Hi,

while displaying date in flat table output is fine

But when it is summed up then total is not matching.



Code used in flat table

(

if(

[Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup)

,(

if([Employment WET]<=vMonthEnd,[Employment WET]+1,vMonthEnd)-

if([Employment WEF]<=vMonthStart,vMonthStart,[Employment WEF]))/(vMonthEnd-vMonthStart)

)

)

Code used at summary level

sum(distinct

if(

[Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup),

( if([Employment WET]<=vMonthEnd,[Employment WET]+1,vMonthEnd)

-

if([Employment WEF]<=vMonthStart,vMonthStart,[Employment WEF])

)

,0)

)

/

sum(distinct

if(

[Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup),

(

(vMonthEnd-vMonthStart)),0

)

)

Thanks

Nishant



1 Reply
Not applicable

Summary level data giving wrong result

Hmm, those look like variables , and the dollar sign is missing everywhere

if([Employment]<=$( vMonthStart ) ..

-Alex

Community Browser