Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

total field

Hi !

I have table with expression (FACT 2012):

sum(if((Aggr(sum({<year={"2012"}, bg_t={'*'}, bg_t-={'b\g}, Holding=>} Quantity),AffiliateID, Holding,mes))>0 ,1,0))

How can i get field with total sum?

please help if you know

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: total field

Try adding total <Dim1,Dim2> to the sum expression. Replace Dim1 and Dim2 with the first two dimensions of your pivot table.

sum(total <Dim1,Dim2>  if((Aggr(sum({<year={"2012"}, bg_t={'*'}, bg_t-={'b\g}, Holding=>} Quantity),AffiliateID, Holding,mes))>0 ,1,0))

See attached example for how it works.


talk is cheap, supply exceeds demand
6 Replies
Not applicable

Re: total field

Total.JPG

MVP & Luminary
MVP & Luminary

Re: total field

Try adding total <Dim1,Dim2> to the sum expression. Replace Dim1 and Dim2 with the first two dimensions of your pivot table.

sum(total <Dim1,Dim2>  if((Aggr(sum({<year={"2012"}, bg_t={'*'}, bg_t-={'b\g}, Holding=>} Quantity),AffiliateID, Holding,mes))>0 ,1,0))

See attached example for how it works.


talk is cheap, supply exceeds demand
Not applicable

Re: total field

Thank you, Gysbert for your help!

I put exemple in you attachment, please look

MVP & Luminary
MVP & Luminary

Re: total field

Hi,

Try this expression

sum(Total<Year, Product, Region>if((Aggr(sum({<year={"2008"}, Product={'*'}, product-={'Banana'}, Holding=>} Sales),Year, Product,Month))>0 ,1

    ,0))

Regards,

jagan.

Not applicable

Re: total field

thank you very much! 

Not applicable

Re: total field

thank you, it works

Community Browser