topic Expression in a chart in QlikView

Expression in a chart

alec1982 — Mon, 18 Jun 2012 19:30:08 GMT

Hi,

I am trying to write script for an expression..

I need the count a field where it is not null.

Thxs for your help,

Anonymous — Mon, 18 Jun 2012 19:33:33 GMT

try this this may help you

COUNT({<field-={""}>} field ID))

alec1982 — Mon, 18 Jun 2012 19:40:44 GMT

Thxs but i got a little confused..

If the field name is XYZ so how it should be?

Thxs

chematos — Mon, 18 Jun 2012 19:44:55 GMT

COUNT({<XYZ-={""}>}distinct XYZ))

alec1982 — Mon, 18 Jun 2012 20:01:06 GMT

I have tried : = COUNT({<[Expiration Date]-={""}>}[Expiration Date]))

and i am getting a red line under the dash before the equal sign!

Any advice?

Thxs,

chematos — Mon, 18 Jun 2012 20:03:13 GMT

Try it although the red line, it must work, I had the same problem before but it works

Mon, 18 Jun 2012 20:05:39 GMT

Yes it will work .

sure ignore red line.