topic Re: expression date in QlikView

expression date

QSense — Thu, 06 Sep 2012 07:52:49 GMT

Hello ,

I have date field called VARDIYARAP_ACILISTARIHIAYYIL_

It includes 2012 and 2011 values but I want to show only 2012 values

Thanks

Re: expression date

daveamz — Thu, 06 Sep 2012 08:01:30 GMT

Hello,

You can use set analysis to filter the data by year. Something like:

sum({<YEAR={2012}> } VARDIYARAP_ACILISTARIHIAYYIL_)

Regards,

David

Re: expression date

Thu, 06 Sep 2012 08:02:42 GMT

sum({$<YEAR={2012}>} VARDIYARAP_ACILISTARIHIAYYIL_)

Re: expression date

thomas_skariah — Thu, 06 Sep 2012 08:03:46 GMT

Hi,

You can either do in edit script with where condition {where year(VARDIYARAP_ACILISTARIHIAYYIL_)=2012}

or you can use if condtion or using set analysis at front end.

Regards,

Tom

Re: expression date

QSense — Thu, 06 Sep 2012 08:25:42 GMT

May I use in dimension part? if so How?

Re: expression date

thomas_skariah — Thu, 06 Sep 2012 08:27:57 GMT

Hi,

You can use if condition in calculated dimension.

Like =if(year(Datecolumn)=2012,Date) and check mark "Suppress when value is null"

Regards,

Tom

Re: expression date

QSense — Thu, 06 Sep 2012 08:32:52 GMT

Hi tom ,

I couldnt write calculated dimension

Re: expression date

thomas_skariah — Thu, 06 Sep 2012 08:38:00 GMT

Hi,

Find the sample application.

Regards,

Tom

Re: expression date

QSense — Thu, 06 Sep 2012 08:44:49 GMT

My Date field is like Jun 2012 so your formula does not work for this case

Re: expression date

thomas_skariah — Thu, 06 Sep 2012 08:46:03 GMT

Is this Jun 2012 is in date format.

Re: expression date

QSense — Thu, 06 Sep 2012 08:47:09 GMT

Char format

Re: expression date

thomas_skariah — Thu, 06 Sep 2012 08:56:29 GMT

Try this one.

Regards,

Tom

Re: expression date

QSense — Thu, 06 Sep 2012 11:30:14 GMT

Hi Tom,

I want to count Id field for only 2012 values

Could you help?