topic Re: Using YEAR function in Set Analysis in QlikView

Using YEAR function in Set Analysis

Wed, 05 Mar 2014 12:35:40 GMT

Hi,

I'm trying to use the Year function in Set Analysis in the following context, but no data are returned. Could anyone advise where I'm going wrong? The formula works normally until I introduce the fourth 'year(INT_DATE)={2014}' condition. I have tried enclosing '2014' in single and double quotes with no luck (when the formula is working as it is, the '2014' will likely be replaced by a variable):

COUNT({$<INT_ACTIVITY_CLASS_INDEX={0},INT_USER_LISTING_ID={2},SEARCH_INDEX={1}, year(INT_DATE)={2014}>} INT_ACTIVITY_ID)

Thanks.

Gavin

Re: Using YEAR function in Set Analysis

MK_QSL — Wed, 05 Mar 2014 12:38:33 GMT

You can't use year(INT_DATE).... it should not be a function but should be a field.

GO to your script and create one more line

year(INT_DATE) as Year

and now use

Year = {2014} or

Year = {'2014'}

Re: Using YEAR function in Set Analysis

Wed, 05 Mar 2014 12:49:19 GMT

Manish is correct. If you want to avoid that and use it in expression, write this

COUNT({$<INT_ACTIVITY_CLASS_INDEX={0},INT_USER_LISTING_ID={2},SEARCH_INDEX={1}>} if(year(INT_DATE)=2014,INT_ACTIVITY_ID))

Re: Using YEAR function in Set Analysis

Wed, 05 Mar 2014 13:48:39 GMT

Thank you both.

Re: Using YEAR function in Set Analysis

2908nmadao — Thu, 22 Jan 2015 13:52:12 GMT

Hi all,

I have a question, I have a filed - Open Date Time and this field format is as follows:

DD/MM/YYY HH:MM:SS

I would like to be able to create, in my script, a YEAR() function referring to this field and gathering per year....

Anyone has an idea?

Thanks

Nelson.

Re: Using YEAR function in Set Analysis

2908nmadao — Thu, 22 Jan 2015 13:52:40 GMT

Hi all,

I have a question, I have a filed - Open Date Time and this field format is as follows:

DD/MM/YYY HH:MM:SS

I would like to be able to create, in my script, a YEAR() function referring to this field and gathering per year....

Anyone has an idea?

Thanks

Nelson.