topic Using a less than (<) modifier in set analysis in QlikView

Using a less than (<) modifier in set analysis

Fri, 26 Aug 2011 14:46:52 GMT

Hi all,

I have a data set that contains dates (INSTDATE) and values (LENGTH).

I want to use set analysis to sum all values less than the date given. The date given will be an input variable which the user enters. Lets say for this example that the date is 01/01/2010.

My attempts at set analysis expressions:

Sum ( {< INSTDATE < {'01/01/2010'} >} LENGTH) ---> doesnt work, can't seem to use < symbol as a modifier

Sum ( {< INSTDATE = $(<'01/01/2010') >} LENGTH) ---> doesn't work

Can anyone tell me how to use a less than operator in set analysis please?

Thanks

Dan

Using a less than (<) modifier in set analysis

Fri, 26 Aug 2011 15:01:04 GMT

Its sorted now, thanks to the links on the right providing another post with the answer!

I use:

Sum ( {< INSTDATE = { "<=$(varname)" } >} LENGTH)

Shame this method isn't in any of the documentation!

Thanks for looking!

Dan

Using a less than (<) modifier in set analysis

SunilChauhan — Fri, 26 Aug 2011 15:27:31 GMT

use this

Sum ( {< INSTDATE = { <(''01/01/2010')" } >} LENGTH)

will this useful?