Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
try
aggr(measure),Dim1,dim2)
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),
Hi ,
This is not working. Does while exporting data to excel number format will have any issue ?
how much do you see the difference?
can you add the rowno() as one more column and see which is missing with the original count?
Hi ,
I added but the still result is off. I am hiding zero values and showing null value in dimension but still same result.
what is the exact number? and what your getting?
In Qlik i am getting let say 6927833.25 while in excel its showing 6702995.61.
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]