sub total in pivot table

[krish2459]

Hi,

sub totals in pivot table not working in qliksense pivot table.

Please look into this.

Thanks,

Krish

[krish2459]

Hi,

Any suggestions please.

Thanks,

Krish

[tresesco]

What is your expression?

[krish2459]

Expression 1:

if([Repeat Flag]='Yes' and (alt(1-(fabs(sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> [Amount LC]))
/
avg({<Type={'Rolling 3'}>}total <Material,Plant>[Stock Value Main])*100),0) < '0.99') and

sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> [Amount LC]) <'-1000',sum( [Amount LC]))

Expression 2:

if([Repeat Flag]='Yes' and (alt(1-(fabs(sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> [Amount LC]))
/
avg({<Type={'Rolling 3'}>}total <Material,Plant>[Stock Value Main])*100),0) < '0.99') and

sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> [Amount LC]) <'-1000',sum([Stock Value Main]))

Thanks,

Krish

[krish2459]

Hi,

Any suggestions please.

Thanks..

[tresesco]

Try a quick fix. Put        Sum(...) around your expression. If this doesn't help, try to share your app with sample data.

[krish2459]

Hi,

I'm getting "Nested Aggregation Not Allowed" error when using the "sum".

Attaching the application with sample data.

Thanks..

[tresesco · Accepted solution]

Try like:

Sum(Aggr(
if([Repeat Flag]='Yes' and (alt(1-(fabs(sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> [Amount LC]))
/
avg({<Type={'Rolling 3'}>}total <Material,Plant>[Stock Value Main])*100),0) < '0.99') and

sum({<[Movemet Type]={'701','702'},Type={'Rolling 3'}>}total <Material,Plant> [Amount LC]) <'-1000',sum( [Amount LC]))
, Material, Plant, MonthYear, [Movemet Type]
))