Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QSense
Contributor II

expression date

Hello ,

I have date field called VARDIYARAP_ACILISTARIHIAYYIL_

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

Thanks

1 Solution

Accepted Solutions
thomas_skariah
Contributor III

Re: expression date

Try this one.

Regards,

Tom

12 Replies
daveamz01
Contributor III

Re: expression date

Hello,

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

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

Regards,

David

Not applicable

Re: expression date

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

thomas_skariah
Contributor III

Re: expression date

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
Contributor II

Re: expression date

May I use in dimension part? if so How?

thomas_skariah
Contributor III

Re: expression date

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
Contributor II

Re: expression date

Hi tom ,

I couldnt write calculated dimension

thomas_skariah
Contributor III

Re: expression date

Hi,

Find the sample application.

Regards,

Tom

QSense
Contributor II

Re: expression date

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

thomas_skariah
Contributor III

Re: expression date

Is this Jun 2012 is in date format.

Community Browser