Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simonb2013
Creator
Creator

Where is null AND something else

I had a working SA to count records where a field (iam_user) was null.

Count(distinct {$-<[iam_user]={"*"}>} rt_sch_obj)

Now I want to alter that, to say include 'AND flag=1'
So I did this : 

Count(distinct {$-<[iam_apex]={"*"}>*$<flag ={1}>} rt_sch_obj)

The results are now showing entries that I know have [iam_user] not null.

 

Getting really confused as to exactly what I'm doing.
Why is this not working as a logical and ?

What is the difference between :
$-<[iam_apex]={"*"}>
vs
$<[iam_apex]-={"*"}>

Lost  of previous questions relating to NULL situations, but can't find one around NULL AND.

 

Thanks for any help !!

Labels (2)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

You need a small trick here. 🙂 Try like:

 

Count(distinct {($-<[iam_apex]={"*"}>)*<flag ={1}>} rt_sch_obj)

 

 

View solution in original post

1 Reply
tresesco
MVP
MVP

You need a small trick here. 🙂 Try like:

 

Count(distinct {($-<[iam_apex]={"*"}>)*<flag ={1}>} rt_sch_obj)

 

 

View solution in original post