topic Re: Set Analysis Help: Showing Dates Prior to a Selected Date in QlikView

Set Analysis Help: Showing Dates Prior to a Selected Date

Wed, 18 Apr 2012 10:15:10 GMT

Hi All,

I'm having issues with a set analysis. I want to display only data in a straight table that has [Inception Date] less than [Date], which I select from a list box.

Inputting only({$<[Inception Date]=[Date]>}[Vhl 1 Age]) woks, and returns all data where the inception date is equal to whichever date i select.

Inputting only({$<[Inception Date]={'<2011-02-01 00:00:00'}>}[Vhl 1 Age]) also works, and returns all data where the inception date is before 01/02/2011.

However, inputting {'<Date'}, {'<[Date]'} or {'<$[Date]'} in place of a specified date doesn't return any values.

Any assistance here would be greatly appreciated.

Ross

Set Analysis Help: Showing Dates Prior to a Selected Date

lironbaram — Wed, 18 Apr 2012 10:41:17 GMT

try to use

only({$<[Inception Date]={"<$(=max([Date]))"}>}[Vhl 1 Age])

Re: Set Analysis Help: Showing Dates Prior to a Selected Date

Wed, 18 Apr 2012 12:29:29 GMT

This works great, thanks. However, this has brought to light a new problem: for rows where there are more than one vehicle age it brings back the policy number, but it doesn't show either of the ages, simply showing a -.

Could you help me with this? Ideally i'd like it to bring back the maximum age, although I could still use the data if it returned both.

Thanks in advance

Ross

Re: Set Analysis Help: Showing Dates Prior to a Selected Date

jonathandienst — Wed, 18 Apr 2012 12:56:35 GMT

Ross

I think you just need to change the 'Only' to 'Max'.

Regards

Jonathan

Re: Set Analysis Help: Showing Dates Prior to a Selected Date

Wed, 18 Apr 2012 12:58:45 GMT

Worked like a charm, thanks.

Ross