Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

prashantsanchet
Contributor

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
Esteemed Contributor

Re: Export to excel total not matching with Qlik Straight table total

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))

26 Replies
sureshqv
Esteemed Contributor III

Re: Export to excel total not matching with Qlik Straight table total

try

aggr(measure),Dim1,dim2)

YoussefBelloum
Esteemed Contributor

Re: Export to excel total not matching with Qlik Straight table total

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
Contributor

Re: Export to excel total not matching with Qlik Straight table total

Hi ,

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

sureshqv
Esteemed Contributor III

Re: Export to excel total not matching with Qlik Straight table total

how much do you see the difference?

sureshqv
Esteemed Contributor III

Re: Export to excel total not matching with Qlik Straight table total

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

prashantsanchet
Contributor

Re: Export to excel total not matching with Qlik Straight table total

Hi ,

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

sureshqv
Esteemed Contributor III

Re: Export to excel total not matching with Qlik Straight table total

what is the exact number?  and what your getting?

prashantsanchet
Contributor

Re: Export to excel total not matching with Qlik Straight table total

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

sureshqv
Esteemed Contributor III

Re: Export to excel total not matching with Qlik Straight table total

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]