Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Re: Return a value based on field's value from a different alternate state

Try this expression

=Sum({<Quarter = Alt1:: Quarter, Meh = {0}>} Aggr(
If(Supplier = Only(TOTAL <Product> Aggr(If(Date = Max(TOTAL <Product> {<Quarter = Alt2::Quarter>} Date), Supplier), Product, Date))
, Sum(Amount))
, Product, Supplier, Date))
Highlighted
amirkachlon
New Contributor III

Re: Return a value based on field's value from a different alternate state

Great, what i was missing is the use of the total by product. Great solution thanks