topic Counting field values where another field is null in QlikView

Counting field values where another field is null

ryanfoster84 — Tue, 23 Feb 2016 14:51:32 GMT

Hi,

i am counting the number of hashtags where the campaign field is blank and am using the following formula:

=count({1-<

[Campaign Name]={*}

>}[Hashtags])

this works fine and i am generating the top 10 (see below)

Hashtags	Total
	14300
CMED	71
NNLN	45
OptionsFocus	39
Ultra10	33
BZ	20
directoptions;OptionsFocus	19
agoptions	16
Treasuries	16
NNLN;OptionsFocus	13

the issue is i want the count to exclude also the blank hashtags and have tried using the table properties (Dimensions) to suppress the null values in hashtags field but this doesn't work. can anyone assist?

thanks

ryan

Re: Counting field values where another field is null

sunny_talwar — Tue, 23 Feb 2016 18:33:09 GMT

May be this:

=Count({1-<[Campaign Name]={*}, Hashtags = {"=Len(Trim(Hashtags)) > 0"}>}[Hashtags])

=Count({1-<[Campaign Name]={*}, Hashtags = {"=Len(Trim(Hashtags)) = 0"}>}[Hashtags])

Re: Counting field values where another field is null

ryanfoster84 — Wed, 24 Feb 2016 08:08:26 GMT

Hi,

No this doesn't work it just count the total of each hashtags. basically the table above i don't want blanks include so the top ten will have values

Hashtags	Total
I WANT THIS REMOVED	14300
CMED	71
NNLN	45
OptionsFocus	39
Ultra10	33
BZ	20
directoptions;OptionsFocus	19
agoptions	16
Treasuries	16
NNLN;OptionsFocus	13