topic Re: Set Analysis - >= of a String Value in QlikView

Set Analysis - >= of a String Value

SNarendran — Tue, 17 Dec 2019 20:56:43 GMT

Hi,

I have a yearmonth field in my script.

It reads like 2017-01.

I want my set analysis expression to give me a count of values from another field when the yearmonth field is >= '2017-01'.

What will my set analysis expression be?

COUNT({<YearMonth_Created ={">= Date#(2017-01)"} >} NL_MLS) doesn't work

Re: Set Analysis - >= of a String Value

Taoufiq_Zarra — Tue, 17 Dec 2019 21:13:59 GMT

Hi,

I suggest you create a field from the [YearMonth_Created] field in the load script:

Date(Date#(YearMonth_Created,'YYYYY-MM')) as New_YearMonth_Created,

then uses this field in set analysis

=COUNT({<New_YearMonth_Created ={">= Date(Date#('2017-01','YYYY-MM'))"} >} NL_MLS)

Cheers,

Re: Set Analysis - >= of a String Value

SNarendran — Wed, 18 Dec 2019 17:13:03 GMT

Thank you

Re: Set Analysis - >= of a String Value

manoranjan_d — Wed, 18 Dec 2019 18:24:08 GMT

Pls accept the solution and close the post as solved

Re: Set Analysis - >= of a String Value

SNarendran — Wed, 18 Dec 2019 18:36:34 GMT

Doesn't work unfortunately

Re: Set Analysis - >= of a String Value

Taoufiq_Zarra — Wed, 18 Dec 2019 18:39:44 GMT

can you share a sample of your data?

Re: Set Analysis - >= of a String Value

SNarendran — Wed, 18 Dec 2019 18:57:49 GMT

Attached. I want to be able to show:

A count of MLS and newMLS From the beginning of my Solddate.

Thanks

Shashank

Re: Set Analysis - >= of a String Value

SNarendran — Wed, 18 Dec 2019 18:58:36 GMT

Dimension has to be CreateDate

Re: Set Analysis - >= of a String Value

Taoufiq_Zarra — Wed, 18 Dec 2019 19:30:15 GMT

if I have understood correctly , both formulas are attached
I don't know if that's the output you want.

Re: Set Analysis - >= of a String Value

SNarendran — Wed, 18 Dec 2019 20:23:32 GMT

Thanks.

If you can create a straight table for me with the Created Date as the dimension and the count of NewMLS as an expression?

Re: Set Analysis - >= of a String Value

Taoufiq_Zarra — Wed, 18 Dec 2019 20:37:02 GMT

for the example you have attached, what do you expect as a result on straight table?

Re: Set Analysis - >= of a String Value

SNarendran — Wed, 18 Dec 2019 20:47:35 GMT

CreatedDate from 2017-01 and its corresponding MLS count,thanks.Shashank

Re: Set Analysis - >= of a String Value

Taoufiq_Zarra — Fri, 20 Dec 2019 08:30:37 GMT

I'm a little confused.
if I understand correctly here you don't need Set Analysis
I attached two versions of the file, one with the values as you requested and another where I linked the two files by the date field and then display the two indicators.
and I don't know if you need a count or sum.

if not, you can attach here an excel file for example where you show exactly what you want (the expected result)

Re: Set Analysis - >= of a String Value

SNarendran — Wed, 18 Dec 2019 22:07:56 GMT

Thanks. Count or sum doesn't matter. I am using count in real time.

I see that you have hard-coded'2017-01' in order to filter the Date created dimension:

= if(New_YearMonth_Created>=Date(Date#('2017-01','YYYY-MM')),New_YearMonth_Created)

I need the hard-coded 2017-01 to be the minstring of the sold date.

And the expression to be a count of the new MLS from the Sold table.

Re: Set Analysis - >= of a String Value

SNarendran — Wed, 18 Dec 2019 22:11:56 GMT

Re: Set Analysis - >= of a String Value

Taoufiq_Zarra — Thu, 19 Dec 2019 08:08:46 GMT

sorry @SNarendran
but I can't see the difference between what you sent and what I sent.

in your example I don't know why there are 22 in 01-2017 then what you sent in the dataset is 70.