Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor II

Re: Count how many time NAME have Null on Flag field ?

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

9 Replies
sivarajs
Valued Contributor II

Re: Count how many time NAME have Null on Flag field ?

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

MVP
MVP

Re: Count how many time NAME have Null on Flag field ?

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
Valued Contributor II

Re: Count how many time NAME have Null on Flag field ?

Hello,

try with this expression in the chart:

  = count((Flag='Null'))

Hope this helps.

Re: Count how many time NAME have Null on Flag field ?

You could use something like this

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

Not applicable

Re: Count how many time NAME have Null on Flag field ?

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
Valued Contributor II

Re: Count how many time NAME have Null on Flag field ?

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

Re: Count how many time NAME have Null on Flag field ?

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

Re: Count how many time NAME have Null on Flag field ?

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

Re: Count how many time NAME have Null on Flag field ?

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.

Community Browser