Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prashantsanchet
Creator
Creator

Export to excel total not matching with Qlik Straight table total

Hi team

I am having Straight Table as Chart

I am having a following as Dimention :  Customer

measure:

if (vPeriod = 'YTD',

if (sum([Cost Price]) <> 0 ,

if (Sum([SP]) <> 0, num(sum([YTDSales]) - Sum([YTDFxSales]), '#,##0'), num(sum([YTDSales]), '#,##0')), 0),

)



Total in the Staright table is showing correct result.

but when i am trying to export this data and try to compare the total in excel and Total in Table is not matching .

What could b the reason .

Please provide your valuable comment as early as possible.

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Try this to replace the one above:

=Sum(aggr(

if((sum([YTD Sales Amount])-sum([LY YTD Sales Amount]))/sum([LY YTD Sales Amount])>-0.45,

(sum([YTD Sales Amount])-sum([LY YTD Sales Amount]))/sum([LY YTD Sales Amount]),sum([YTD Sales Amount])),

Customer))

View solution in original post

26 Replies
Chanty4u
MVP
MVP

try

aggr(measure),Dim1,dim2)

YoussefBelloum
Champion
Champion

Hi,

what is the total type you chose ?

Try this:

if (vPeriod = 'YTD' and sum([Cost Price]) <> 0 and Sum([SP]) <> 0, num(sum([YTDSales]) - Sum([YTDFxSales]), '#,##0'), num(sum([YTDSales]), '#,##0'), 0),

prashantsanchet
Creator
Creator
Author

Hi ,

This is not working. Does while exporting data to excel number format will have any issue ?

Chanty4u
MVP
MVP

how much do you see the difference?

Chanty4u
MVP
MVP

can you add the  rowno()  as one more column and see which is missing with the original count?

prashantsanchet
Creator
Creator
Author

Hi ,

I added but the still result is off. I am hiding zero values and showing null value in dimension but still same result.

Chanty4u
MVP
MVP

what is the exact number?  and what your getting?

prashantsanchet
Creator
Creator
Author

In Qlik i am getting let say 6927833.25 while in excel its showing 6702995.61.

Chanty4u
MVP
MVP

give me two columns  result in excel  and validate row by row .

then you come to know which row/column having the issue.   [it may be format from excel or qlik]