topic Re: Set Analysis Where Date Is Greater Than in QlikView

Set Analysis Where Date Is Greater Than

Anonymous — Mon, 17 Aug 2015 18:10:36 GMT

Trying to only calculate spend where a certain date field is greater than 12/01/2014. Current syntax I have is below but it is not working:

sum({<

Date = Date > {'12/01/2014'} }>}

Spend)

Any help is appreciated.

Thank you,

- dave

Re: Set Analysis Where Date Is Greater Than

swuehl — Mon, 17 Aug 2015 18:13:33 GMT

Try

sum(

{<Date = {">'12/01/2014'"} >}

Spend)

Re: Set Analysis Where Date Is Greater Than

b_garside — Mon, 17 Aug 2015 18:16:17 GMT

This will work. However you may not want a static/hard coded date search parameter.

Sum({$< [Data Type]={'A'} , Date={"> 12/01/2014"}>} Spend)

Re: Set Analysis Where Date Is Greater Than

Anonymous — Mon, 17 Aug 2015 18:17:37 GMT

That did not seem to work. I have an additional statement in the set analysis ... Maybe this is why it does not work ...

sum({<

[Data Type]={'A'},

Date = {">'12/01/2014'"}>}

[Spend])

Re: Set Analysis Where Date Is Greater Than

Anonymous — Mon, 17 Aug 2015 18:25:58 GMT

Brian - Copied and pasted your solution verbatim but its not working for me. Perhaps I am doing something wrong ...

EDIT: I had an extra space between > and the date ... This now works. Thank you .

Re: Set Analysis Where Date Is Greater Than

b_garside — Mon, 17 Aug 2015 18:44:42 GMT

Your welcome, Glad it worked.

Yeah Set Analysis is not to forgiving on syntax issues.

Re: Set Analysis Where Date Is Greater Than

vanand3535 — Wed, 28 Feb 2018 18:19:24 GMT

try this:-

Sum({$< [Data Type]={'A'} , Date={"> 12/01/2014"}>} Spend)

Re: Set Analysis Where Date Is Greater Than

b_garside — Wed, 28 Feb 2018 19:06:31 GMT

Yeah the extra space was my bad. Glad you got it to work

Re: Set Analysis Where Date Is Greater Than

publication1 — Wed, 28 Oct 2020 14:04:22 GMT

Hi Brian, I have tried all these below and my value each time has been ZERO (0)

I have ran this in my database and answer should be 10

Do you see anything I am doing wrong (im thinking it can be a date format issue perhaps ?)

*** FAILED ATTEMPTS ***

COUNT({$<DELIVERY_DATE = {">04/12/2018"}>} ITEM_NAME)
COUNT({$<DELIVERY_DATE = {">04/12/2018"}>} ITEM_NAME)
COUNT({$<DELIVERY_DATE = {">'04/12/2018'"} >}ITEM_NAME)
COUNT({$<DELIVERY_DATE = {">'04/12/2018'"}>}[ITEM_NAME])
COUNT({$<DELIVERY_DATE = {">04/12/2018"}>}[ITEM_NAME])
COUNT({$<DELIVERY_DATE = {'>04/12/2018'}>}[ITEM_NAME])