topic Re: How can I use greater than(>=) in Set analysis in QlikView

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

Sai_Mohan — Sat, 16 Nov 2024 00:16:02 GMT

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!

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

hector — Thu, 23 Jul 2020 20:16:02 GMT

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

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

regards

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

Kushal_Chawda — Thu, 23 Jul 2020 20:35:19 GMT

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)

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

Sai_Mohan — Thu, 23 Jul 2020 20:40:24 GMT

Hi @Kushal_Chawda

Thanks for the help!

It works fine

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

Sai_Mohan — Thu, 23 Jul 2020 20:40:56 GMT

Hi @hector

Thanks for the help!

It works fine

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

PDurnall — Tue, 17 Oct 2023 08:01:31 GMT

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)