topic Re: GAP in QlikView

GAP

master_student — Tue, 23 Aug 2016 13:47:07 GMT

Hello Guys,

My pb is the sum displayed on QV is not equal to the sum after exract excel

I am using a pivot table with 3 dimensions LB/CDR/Famille. whene I delete the CDR dimension, the amount becomes correct.

How can I fix that pb.

Thanks

Re: GAP

sunny_talwar — Tue, 23 Aug 2016 13:48:39 GMT

May be use Aggr() function

Sum(Aggr(YourExpression, LB, CDR, Famille))

Here YourExpression is a placeholder for your actual expression.

Re: GAP

Or — Tue, 23 Aug 2016 13:51:33 GMT

It's very difficult to guess what your problem is, since you have not posted any actual information, just a screenshot of your totals. My best guess - you have "Supress when Value is Null" on the CDR dimension, and one or more rows do not have a value for this dimension.

Re: GAP

master_student — Tue, 23 Aug 2016 13:57:24 GMT

Bellow the expression I am using:

sum( {< $(vSetView) >} $(vBudgetReceprionFcst) )

whene applying your suggestion. there's no value..

vSetView=pick(ViewId,

'$(vSetMTD)',

'$(vSetYTD)',

'$(vSetTotal)')

vBudgetReceprionFcst = pick(TypeID,

[Budget RECEPTION FCT] ,

[Fcst 3+9 RECEPTION FCT],

[Fcst 6+6 RECEPTION FCT],

[Fcst 9+3 RECEPTION FCT])

Any idea, please?

Re: GAP

Anil_Babu_Samineni — Tue, 23 Aug 2016 14:10:29 GMT

What are these

'$(vSetMTD)',

'$(vSetYTD)',

'$(vSetTotal)')

Re: GAP

master_student — Wed, 24 Aug 2016 07:29:18 GMT

'$(vSetMTD)'= [Calendar date]= , [Month of date]={ "= $(=max([Month of date]))"}, [%Date ID] = { "<= $(=max([%Date ID]))"}

It 's month to date/year to date / Total year ..