topic Re: 'Bug' in Straight Table & Pivot Table Subtotal & Total in QlikView

'Bug' in Straight Table & Pivot Table Subtotal & Total

Anonymous — Wed, 25 May 2016 01:45:30 GMT

I encountered below 'bug' when trying to develop some reports for my client.

Straight Table & Pivot Table subtotal & total are wrong (circled in red). They are based upon 'expression' instead of 'sum of total' which cannot be controlled by us :

Please help. I also attach the qvw file for easy reference.

Thanks,

Eric

Re: 'Bug' in Straight Table & Pivot Table Subtotal & Total

Gysbert_Wassenaar — Wed, 25 May 2016 07:11:57 GMT

It's not a bug. You're using an expression that's not a pure sum that be totaled as-is at every level. The expressions is also evaluated at the total levels and the result there is not the same as the sum of the results at the detailed level because of your if statement. What you want is the sum of an aggregation expression: sum( aggr( ...your_expression...), Type, Date, Description)): sum(aggr( if(Profit<0,0,Profit*.3) ,Type,Date,Description))

Re: 'Bug' in Straight Table & Pivot Table Subtotal & Total

qlikview979 — Wed, 25 May 2016 07:29:16 GMT

Hi,

Please find the attached file

Regards,

Mahesh

Re: 'Bug' in Straight Table & Pivot Table Subtotal & Total

Anonymous — Wed, 25 May 2016 07:33:26 GMT

Thanks Wassenaar! It works now.

Regards,

Eric

Re: 'Bug' in Straight Table & Pivot Table Subtotal & Total

Anonymous — Wed, 25 May 2016 07:35:01 GMT

Thanks Mahesh for your reply! By the way, I only have personal version so cannot open your file.

Re: 'Bug' in Straight Table & Pivot Table Subtotal & Total

kamal_sanguri — Wed, 25 May 2016 07:37:31 GMT

Hi,

This might be easy to understand..

use this expression to calculate your tax:

=sum(if(Profit>0,Profit* .3))

The problem with your expression is it is taking sum of all the items although you are replacing them with '0' .

-Kamal