expression date

[QSense]

Hello ,

I have date field called VARDIYARAP_ACILISTARIHIAYYIL_

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

Thanks

[daveamz]

Hello,

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

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

Regards,

David

[#3]

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

[thomas_skariah]

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

[QSense]

May I use in dimension part? if so How?

[thomas_skariah]

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

[QSense]

Hi tom ,

I couldnt write calculated dimension

[thomas_skariah]

Hi,

Find the sample application.

Regards,

Tom

[QSense]

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

[thomas_skariah]

Is this Jun 2012 is in date format.