topic Comaparing amounts with Set Analysis in QlikView

Comaparing amounts with Set Analysis

Tue, 08 Dec 2009 21:27:13 GMT

Hi!

I'm trying to compare the Hours for a period and only show those > 100000.

Can anybody explain why my syntax is wrong?

sum( {"=sum{$<PeriodCounter = {"$(#=max(PeriodCounter))"}>} REPORTED_HOURS )> 1000000"}>} REPORTED_HOURS )

Thanks!

Johan

Comaparing amounts with Set Analysis

Tue, 08 Dec 2009 21:40:53 GMT

Hi Johan,

please provide an example we can work with.

Thank you!

Rainer

Comaparing amounts with Set Analysis

Tue, 08 Dec 2009 21:47:11 GMT

Hi!

Actually my example is fetch from the Help text. This is the syntax I modified.

sum( {$<Customer = {"=Sum({1<Year = {2007}>} Sales ) > 1000000"}>} Sales )
returns the sales for current selection, but with a new selection in the "Customer" field: only customers who during 2007 had a total sales of more than 1000000.

This not working either.

/Johan