topic QV 9 and set analysis in QlikView

QV 9 and set analysis

Wed, 10 Feb 2010 12:00:09 GMT

I am in the process of upgrading from 8.5 to version 9. Set analysis formulas created in 8.5 do do work in version 9, can anybody explain, e.g. sum({$<ON_order_no <>{''}>} despatched_qty)

QV 9 and set analysis

Miguel_Angel_Baeyens — Wed, 10 Feb 2010 12:19:56 GMT

Hello,

You can try

Sum({< ON_order_no = {"<>''"} >} despatched_qty)

If you are trying to avoid null/empty values try

Sum({< ON_order_no = {"=len(ON_order_no) > 0"} >} despatched_qty)

QV 9 and set analysis

Wed, 10 Feb 2010 12:29:54 GMT

Thanks, the second formula works. I have a large number of reports using set analysis and no doubt there will be a problem when I upgrate to version 9 SR2.

Is there an explanation as to why the formulas need to be changed?

QV 9 and set analysis

Miguel_Angel_Baeyens — Wed, 10 Feb 2010 12:48:05 GMT


carneyfm wrote:Is there an explanation as to why the formulas need to be changed?

It may be because of the changes in Set Analysis, and probably documented in the release notes of V9. Not sure though