topic Re: Set analysis syntax errore in QlikView

Set analysis syntax errore

Tue, 26 Jan 2016 16:42:36 GMT

Hi,

How to Hide Selected Field in Set analysis code and how to remove null in script level while loding .

Thanks.

swuehl — Tue, 26 Jan 2016 16:44:12 GMT

Use only one set modifier per field:

Sum({$<Shipping_Status-={'Rejected','Hold'} >}Revenue)

swuehl — Tue, 26 Jan 2016 16:46:23 GMT

And for filtering status in the LOAD, something like

LOAD (Shipping_Status) as Shipping_Status,

(Country) as Country ,

(Areacode) as Areacode ,

(Payment_Mode) as Payment_Mode,

(Revenue) as Revenue

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE (Shipping_Status) <> 'NULL';