topic Re: help on Expression in QlikView

help on Expression

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have one expression where I am calculating count of all BLANK values like below.

=(count({<myfield={''}>}myfield)/count(myfield) )

Now I want to use another expression which will give me count of all NON BLANK values.

Is short, how to add NOT operator in the above expression.

Thanks

avinashelite — Fri, 04 Mar 2016 08:06:06 GMT

try like this

=(count({<myfield - ={''}>}myfield)/count(myfield) )

maxgro — Fri, 04 Mar 2016 08:07:36 GMT

try

=( count({<myfield={"=Len(Trim(myfield)) = 0"}>}myfield) / count(myfield) )

avinashelite — Fri, 04 Mar 2016 08:08:41 GMT

if(len(trim(myfield)>0,count(myfield) )

tamilarasu — Fri, 04 Mar 2016 08:11:45 GMT

Try like below,

=count({<myfield={'*'}>}myfield)/count(myfield)

=count({<myfield={"=Len(Trim(myfield)) <> 0"}>}myfield) / count(myfield)

MayilVahanan — Fri, 04 Mar 2016 08:15:02 GMT

Try like this

=( count({<myfield={"=Len(Trim(myfield)) = 0"}>}myfield)

jagan — Fri, 04 Mar 2016 08:17:34 GMT

Hi,

Try this

=(count({<myfield={''}>}myfield)/count(myfield) )

The best approach is to handle this in script

LOAD

If(Len(Trim(FieldName)) = 0 , 1, 0) AS Flag

FROM DataSource;

Now use below expression

For Blank values:

=(count({<Flag={1}>}myfield)/count(myfield) )

For Non Blank values:

=(count({<Flag={0}>}myfield)/count(myfield) )

Hope this helps you.

Regards,

Jagan.