Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count how many time NAME have Null on Flag field ?

Hi All

I try to count how many time user have null on Flag, i use

My chart expression = count(distinct(Flag=Null))

it does not able to work.

Any advise ?

Paul

1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

count((if(Flag='Null',Name)))

View solution in original post

9 Replies
sivarajs
Specialist II
Specialist II

count((if(Flag='Null',Name)))

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

To count nulls in the Name field:

=NullCount(Name)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
salto
Specialist II
Specialist II

Hello,

try with this expression in the chart:

  = count((Flag='Null'))

Hope this helps.

CELAMBARASAN
Partner - Champion
Partner - Champion

You could use something like this

=Count({<Flag={'Null'}>} Name)

Not applicable
Author

Hi All

Thank you very much for all the help . I notice that only Siva script working , may be because he Add NAME in the script.

I have next follow up question , may i know how to make the Top of bar display the number of count , now it display 00:00

How to make it display 1 or 3

Paul

sivarajs
Specialist II
Specialist II

Change the number format to integer. You get number option under chart properties

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

Change the number format in the Number tab, you specified it as Time.

I prefer to use set analysis which is cost effective, Count({<Flag={'Null'}>} Name).

Not applicable
Author

Hi Cela

Yes now it work fine on display count number on top of the bar.

Can you tell me why SET analysis is better ?

Paul

CELAMBARASAN
Partner - Champion
Partner - Champion

Set analysis filters the data from the datamodel before it applies dimension based evaluation. But using if condition, filter applied on the dimension evaluation.

To say simply, Set analysis filters the data based on the condition in whole data set and applies the filtered data to the dimension values. But the if condition apply filters for each and every dimension values.