Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
HH3571
Contributor II
Contributor II

Set analysis expression

Hello i have the following problem:

I have a column/dimension with user names and a date.

 

|User_Login|        |Date|

User1                      2022-xx-xx

User2                     null

User1                     2022-xx-xx

User3                     2022-xx-xx

I have some Users that doesn't have a date, and i want to ignore those in my count of users.

I would like to show the count of user names from this table, in regards to if it has a date.

So if i would express it logically it would be something like:

Count user_login if Date exist, give a value, if date null=skip.

 

So far:

i have something like "Count({USER_LOGIN ={${<USER_LOGIN ={"=Sum(DATE)>0"}>}USER_LOGIN ))}>" and it doesn't work.

 

Br

 

 

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Why not just Count(Date)?

 

View solution in original post

1 Reply
Or
MVP
MVP

Why not just Count(Date)?