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: 
Sai_Mohan
Contributor III
Contributor III

How can I use greater than(>=) in Set analysis

Hi All,

I need to get distinct count of user_id by giving two condition .

1st Cond = 'Completed = 'yes' (Completed is column name)

2nd cond = 'Date >= '07/01/2020' (date s column name)

I have used:


count(Distinct{<Completed = {'Yes'}, Date = {">=$ ('07/01/2020')"}>} UserID) - Not getting any error but getting value as zero.

Note : I am unable to give greater than symbol.

Thanks in Advance!

 

Labels (1)
2 Solutions

Accepted Solutions
hector
Specialist
Specialist

Hi

if "date" is a valid date field (interpreted by Qlik), you can use

count(Distinct{<Completed = {Yes}, Date = {">=07/01/2020"}>} UserID)

regards

View solution in original post

Kushal_Chawda

You don't need $ for hard-coded values. Just encapsulate value in in double quotes. Make sure that the value format should match with Date field format.

count(Distinct{<Completed = {'Yes'}, Date = {">=07/01/2020"}>} UserID) 

View solution in original post

5 Replies
hector
Specialist
Specialist

Hi

if "date" is a valid date field (interpreted by Qlik), you can use

count(Distinct{<Completed = {Yes}, Date = {">=07/01/2020"}>} UserID)

regards

Kushal_Chawda

You don't need $ for hard-coded values. Just encapsulate value in in double quotes. Make sure that the value format should match with Date field format.

count(Distinct{<Completed = {'Yes'}, Date = {">=07/01/2020"}>} UserID) 

Sai_Mohan
Contributor III
Contributor III
Author

Hi @Kushal_Chawda 

Thanks for the help!

It works fine 

Sai_Mohan
Contributor III
Contributor III
Author

Hi @hector 

Thanks for the help!

It works fine 

PDurnall
Contributor II
Contributor II

Also to note that

count(Distinct{<Completed = {Yes}, Date = {">=07/01/2020"}>} UserID) Works 

but if you put a space here between the >= and the Date like below it doesn't work 

count(Distinct{<Completed = {Yes}, Date = {">= 07/01/2020"}>} UserID)