topic Re: Set analysis Date Range in QlikView

Set analysis Date Range

Sun, 16 Aug 2015 16:35:39 GMT

Hello Community,

I have a problem with set analysis. What i wnat to do is count a certain ID, for the last fives year,

here is my expression

My solution : Count({$<Date={'>=(Max(Year(Date)))<=(Max(Year(Date)))-5>} DISTINCT([ID SIG])

But this ins't work !

If someone have the solution, i'll apreciate it. Thanks.

Re: Set analysis Date Range

sunny_talwar — Sun, 16 Aug 2015 16:40:22 GMT

This may be:

Count({$<Date={"$(='>=' & Date(AddYears(Max(Date), -5), 'YourDateFormat') & '<=' & Date(Max(Date), 'YourDateFormat'))>} DISTINCT [ID SIG])

Re: Set analysis Date Range

Sun, 16 Aug 2015 16:45:39 GMT

Hello Sunny,

Pour info, [Date] is my date field (is a numeric date format), so what i have to do with 'AddYears' and 'YourDateFormat' ?

Thnks you

Re: Set analysis Date Range

maxgro — Sun, 16 Aug 2015 16:50:23 GMT

=count({<Date={">=$(=Date(AddYears((Max(Date)),-5)))<=$(=Date(Max(Date)))"}>} distinct [ID SIG])

=count({<Date={">=$(=Num(AddYears((Max(Date)),-5)))<=$(=Num(Max(Date)))"}>} distinct [ID SIG])

Re: Set analysis Date Range

sunny_talwar — Sun, 16 Aug 2015 16:55:19 GMT

You won't need to worry about AddYears. For YourDateFormat -> You need to make sure that you input the format Date Field is in within the Single Quotes. For instance if Date is in this format MM/DD/YYYY then use this within single quotes.

HTH

Best,

sUNNY

Re: Set analysis Date Range

sunny_talwar — Sun, 16 Aug 2015 16:55:56 GMT

Sorry missed a double quote at the end:

Count({$<Date={"$(='>=' & Date(AddYears(Max(Date), -5), 'YourDateFormat') & '<=' & Date(Max(Date), 'YourDateFormat'))">} DISTINCT [ID SIG])

Re: Set analysis Date Range

jagan — Sun, 16 Aug 2015 17:05:12 GMT

Hi,

If date is numeric format then try below expression

=count({<Date={">=$(=Num(AddYears((Max(Date)),-5)))<=$(=Num(Max(Date)))"}>} distinct [ID SIG])

Regards,

Jagan.

Re: Set analysis Date Range

Sun, 16 Aug 2015 17:20:21 GMT

Thanks you guys, it works great !!!