topic Date in Set Analysis?? in QlikView

Date in Set Analysis??

Tue, 28 Sep 2010 13:15:24 GMT

Hi All,

This I think is a very basic query.

I am a new user. I am working on a chat where there are dates in a field. I am looking to filter the records from that field based on the year 2010. the date format in the records is "mm/dd/yyyy 00:00:00". I have little knowledge of Set Analysis and I have already used a espression to filter the data. In short I want to see the data pertaining only to 2010.

Any help is appreciated, Thanks in Advance.

Re. :Date in Set Analysis??

martin59 — Tue, 28 Sep 2010 13:21:18 GMT

In Set Analysis :

{<Date={">=01/01/2010 00:00:00"}>}

There is a better way by creating a year field :

Year(Date) as Year

Date in Set Analysis??

Tue, 28 Sep 2010 13:22:26 GMT

Hi Mady_mama,

You could try something like: sum( {$<Year = {2010}>} Sales

Not sure if what you want to measure. count, sum etc........you can just replace this with your requirement.

I hope this points you in the right direction.

Re. :Date in Set Analysis??

Tue, 28 Sep 2010 14:20:34 GMT

Martin,

Bloody Hell, Thanks man it worked... It was so simple and I was trying for 2 hrs now..

Date in Set Analysis??

Tue, 28 Sep 2010 14:21:35 GMT

Thank you XENA,

Martins reply seems to have worked for me for now. However ty for the reply...

Re. :Date in Set Analysis??

Tue, 28 Sep 2010 14:30:20 GMT

Hello Martin,

Another query pls.. How can I select a null value is Set Analysis? I am working on 2 expressions and for one there are values but for the other one I need to check for Null values (originally there are dates in this column though).

Mady

Re. :Re: Re. :Date in Set Analysis??

martin59 — Tue, 28 Sep 2010 14:35:41 GMT

I will recommend you to do this :

{<Field={"$(=Null())"}>}

But I'm not sure I understood correctly

Re. :Date in Set Analysis??

Miguel_Angel_Baeyens — Tue, 28 Sep 2010 14:47:53 GMT

Hello,

Try

Sum({1 - < FieldWithNulls = P(FieldWithNulls) >} Sales)

Hope that helps

Re. :Re: Re. :Date in Set Analysis??

Tue, 28 Sep 2010 14:59:01 GMT

Martin,

Well I have a DairyCompletedDate where I need to run a filter only on the blank dates. The null values in my fields are shown an '-' I dont think that is a valid character though. Inshort I need to filter and fetch the null values and do we really need Set Analysis here ... If not then how can i include this expression with another filter expression I have for the same chart..?

Hope this is a bit elaborate than the previous post 🙂

Thanks in Advance

Mady

Re. :Re: Re. :Re: Re. :Date in Set Analysis??

martin59 — Wed, 29 Sep 2010 13:47:19 GMT

You can try without Set Analysis :

sum(if(isnull(DairyCompletedDate), Sales))

sum(if(len(trim(DairyCompletedDate))=0,Sales))

Hope that helps you