topic Re: max date for current quarter in QlikView

max date for current quarter

Wed, 08 Apr 2015 10:32:42 GMT

Hi ,

How do we use <=max(date) for current quarter in set expression.

below max(REQ_DATE) return 12/31/2015 but i want to compare with current quarter max date i.e 6/30/2015.

Sum({$< Type = {'O'}, C_TYPE = {'Y'}, Year = {$(#vFYear)}, Quarter = {$(#vFQuarter)} ,REQ_Year = {$(#vFYear)}, REQ_DATE = {"<=$(=max(REQ_DATE))"}>} USD_NET_VALUE) / 1000

Thanks

Rajesh G

Re: max date for current quarter

sunny_talwar — Wed, 08 Apr 2015 10:36:18 GMT

Maybe something like this:

Sum({$< Type = {'O'}, C_TYPE = {'Y'}, Year = {$(#vFYear)}, Quarter = {$(#vFQuarter)} ,REQ_Year = {$(#vFYear)}, REQ_DATE = {"<=$(=max(<{Quarter = {$(#vFQuarter)}>}REQ_DATE))"}>} USD_NET_VALUE) / 1000

Best,

Sunny

Re: max date for current quarter

sunny_talwar — Wed, 08 Apr 2015 10:38:19 GMT

My guess is that #vFQuarter is related to current quarter? right?

Re: max date for current quarter

Wed, 08 Apr 2015 10:44:21 GMT

Yes correct #vFQuarter related to current quarter,let me check your expression

Re: max date for current quarter

Wed, 08 Apr 2015 10:55:20 GMT

no its not return correct value,looks some thing wrong

Re: max date for current quarter

sunny_talwar — Wed, 08 Apr 2015 10:56:50 GMT

What do you see when you put this in a text box: =max(<{Quarter = {$(#vFQuarter)}>}REQ_DATE)? Do you see 06/30/2015

Re: max date for current quarter

sunny_talwar — Wed, 08 Apr 2015 10:59:45 GMT

Also you might have to use Date() to make sure that max doesn't spits out a number result instead of a date

Sum({$< Type = {'O'}, C_TYPE = {'Y'}, Year = {$(#vFYear)}, Quarter = {$(#vFQuarter)} ,REQ_Year = {$(#vFYear)}, REQ_DATE = {"<=$(=Date(max(<{Quarter = {$(#vFQuarter)}>}REQ_DATE), 'yourDateFormat'))"}>} USD_NET_VALUE) / 1000

Re: max date for current quarter

Anonymous — Wed, 08 Apr 2015 10:59:53 GMT

Hi,

you can directly use QuarterEnd(today()) for current quarter max date it will return 30-06-15

you dont need to have multiple filters for year and all.

Thanks

BKC