topic Re: Set Analysis OR syntax in QlikView

Set Analysis OR syntax

Mon, 10 Feb 2014 15:39:01 GMT

I am trying to add an additional parameter to a set analysis expression -

where client leave date = 01/01/1900 OR client leave date >= a loaded variable vDateStartWeek

Trying variances of the below but I cannot get it display correctly?

[Client leaveDate] = {01/01/1900}> + <[Client leaveDate] = {">=$(=Date(vDateStartWeek))"}>},

giakoum — Mon, 10 Feb 2014 15:42:12 GMT

[Client leaveDate] = {01/01/1900} + {">=$(=Date(vDateStartWeek))"}>}

Gysbert_Wassenaar — Mon, 10 Feb 2014 15:46:26 GMT

Try {<[Client leaveDate] = {'01/01/1900', '>=$(=Date($(vDateStartWeek)))'}>}

Mon, 10 Feb 2014 15:57:48 GMT

Thank you, works well.