topic Using a Max and Min Date Variable in set analysis in QlikView

Using a Max and Min Date Variable in set analysis

Wed, 02 Mar 2011 11:03:24 GMT

I can't seem to get this set analysis working. I'm selecting a range of months from a list box and using two variables to get the maximum and minimum dates from my selection.

If I use them in the following expression I find the minimum formula works fine but the maximum formula is not working and if I reverse the formula the maximum works fine and the minimum doesn't!

sum ({<NL_Month = {'<=$(vMaxNL_Month'), NL_Month = {'>=$(vMinNL_Month)'} >} NL_Value

Any suggestions in how to pick up just the NL_Value between the minimum and maximum month?

Using a Max and Min Date Variable in set analysis

Wed, 02 Mar 2011 11:34:25 GMT

Hi Andy,

try this:

sum ({<NL_Month = {"<=$(vMaxNL_Month')>=$(vMinNL_Month)"} >} NL_Value)

Good luck!

Rainer

Using a Max and Min Date Variable in set analysis

Wed, 02 Mar 2011 12:52:07 GMT

Rainer

Thank you - this worked fine after taking the stray ' out after vMaxNL_Month!

Cheers