Discussion Board for collaboration related to Creating Analytics for QlikView.
Is there a way, using Set Analysis, to aggregate row amounts by an ID, then only show aggregation sums > $99k
Invoice # row Amount
Invoice Line 1 . 333 75,000Invoice Line 2 333 25,000Invoice Line 1 334 5,000Invoice Line 2 334 1,000Results: Invoice 333 100,000
Assuming this data
Table1:LOAD * INLINE [Line, Invoice, AmountInvoice Line 1, 333, 75.000Invoice Line 2, 333, 25.000Invoice Line 1, 334, 5.000Invoice Line 2, 334, 1.000];
Create a chart object, Straight table, set Invoice as Dimension and the following as expression should work
If(Aggr(Sum(Amount), Invoice) >= 100000, Aggr(Sum(Amount), Invoice))
Hope this helps
Is there a specific reason you like to use set analysis? The following should give the result you specified.
Make a straight table using
=if(Sum([row Amount]) >= 100000,sum([row Amount]))
Miguel,that works, but it doesn't show totals of all invoices in the straight table or pivot table.
Miguel and Nilsberg,
Thanks for your answers.I got my Set Analysis expression to work.