Discussion Board for collaboration related to QlikView App Development.
I am facing issue with Total Mode Sum and Expression Total .If i am selecting Sum as a total mode its giving proper count if i am trying to change it to Expression total value returning 1
count(DISTINCT aggr(if(AGGR(if(min(DRAWING_REVISION_Number)='','',if(min(TOTAL<Test> DRAWING_REVISION_Number) and min(DRAWING_REVISION_Number)=1,'1',if(min(TOTAL<Test> DRAWING_REVISION_Number)=min(DRAWING_REVISION_Number),-1,min(DRAWING_REVISION_Number)))),DRAWING_REVISION_Number,Test)>1,COUNT(DISTINCT Test)),DRAWING_REVISION_Number, Test))
Are you using any synthetic dimension in your chart?
can you try with sum of rows option? still same issue?
Sum of rows giving proper O/P as i shown in screenshot