Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Expression in a chart

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,

6 Replies
Anonymous
Not applicable

try this this may help you

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

alec1982
Specialist II
Specialist II
Author

Thxs but i got a little confused..

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

Thxs

chematos
Specialist II
Specialist II

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

alec1982
Specialist II
Specialist II
Author

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
Specialist II
Specialist II

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

Not applicable

Yes it will work .

sure ignore red line.