Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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
Creator III
Creator III

Try this one.

Regards,

Tom

View solution in original post

12 Replies
daveamz
Partner - Creator III
Partner - Creator III

Hello,

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

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

Regards,

David

Not applicable

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

thomas_skariah
Creator III
Creator III

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
Creator II
Creator II
Author

May I use in dimension part? if so How?

thomas_skariah
Creator III
Creator III

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
Creator II
Creator II
Author

Hi tom ,

I couldnt write calculated dimension

thomas_skariah
Creator III
Creator III

Hi,

Find the sample application.

Regards,

Tom

QSense
Creator II
Creator II
Author

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

thomas_skariah
Creator III
Creator III

Is this Jun 2012 is in date format.