Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
tomdabek
Contributor III
Contributor III

Struggle with Set Analysis / Aggr in chart straight table output

I am struggling to get defined output in cells of a straight table when they are not totally related to the dimension.

In the table below i know i have to have some kind of formula with

sum([set analysis]

   aggr( 

          sum ([set analysis])

          , dimensions for the aggr function)))

But i conceptually cannot figure out how to make this work to get correct values in Customer Volume and Product Volume.

CustomerProjectProductVolumeCustomer VolumeProduct Volume
BillAFence4236
BillAGate9239
BillADoor102315
SteveBDoor5515
SteveCFence226
1 Solution

Accepted Solutions
sunny_talwar

May be try these:

Customer Volume

Sum(TOTAL <Customer> Volume)

Product Volume

Sum(TOTAL <Product> Volume)

View solution in original post

2 Replies
sunny_talwar

May be try these:

Customer Volume

Sum(TOTAL <Customer> Volume)

Product Volume

Sum(TOTAL <Product> Volume)

View solution in original post

galax_allu
Specialist
Specialist

Hi

try this.

aggr(sum(Volume),Customer)

and

aggr(sum(Volume),Product)







FYI


set analysis will give you kind of filter :


if you want only customer : 'Bill' grouping by Product then...


aggr(sum( {<Customer={'Bill'}  >}Volume),Product)


But in your case , i do not think this helps ...