topic Re: Count in chart in QlikView

Count in chart

pradeep92 — Fri, 10 Nov 2017 09:41:57 GMT

When I give Count(OrderNumber) i get only 9 records leaving the null value in CHART whereas in Script it is showing 9 records..

GIVEN IN HELP :

Count(OrderNumber)

10, because there are 10 fields that could have a value for OrderNumber, and all records, even empty ones, are counted.

Temp:

LOAD * inline [

Customer|Product|OrderNumber|UnitSales|UnitPrice

Astrida|AA|1|4|16

Astrida|AA|7|10|15

Astrida|BB|4|9|9

Betacab|CC|6|5|10

Betacab|AA|5|2|20

Betacab|BB|1|25| 25

Canutility|AA|3|8|15

Canutility|CC|||19

Divadip|CC|2|4|16

Divadip|DD|3|1|25

] (delimiter is '|');

what is the exact output :

shraddha_g — Fri, 10 Nov 2017 09:45:02 GMT

Count(OrderNumber) will give you 9 as a result.

Anonymous — Fri, 10 Nov 2017 09:49:33 GMT

I just copy your script in Qlikview and it show like this below:

shraddha_g — Fri, 10 Nov 2017 09:51:19 GMT

IN that case, It is not considering Order Number as 'Null' but 'Blank'

dwarikapanigrah — Fri, 10 Nov 2017 10:08:19 GMT

Hi Pradeep

Its a good question , QV treated a blank space as a information rather as null.

So in your first case it should give Count(OrderNumber) =10 .

Now if you handle null condition like below "Set NullInterpret = ''; " now Count(OrderNumber) = 9.

Please refer the QVW.

antoniotiman — Fri, 10 Nov 2017 10:11:08 GMT

If You want to consider OrderNumber as Null You need to add

set NullInterpret='';

then Count(Orders) = 9

pradeep92 — Fri, 10 Nov 2017 12:54:04 GMT

Thanks everyone for the quick response!