topic Re: Expressions with {1} in QlikView

Expressions with {1}

Thu, 06 Nov 2014 17:58:02 GMT

Hi,

From the set analysis document, if we have an expression like

SUM({1}net)

it will ignore all selections except for the dimensions.

I have the following expression for a table with dimension ='Dimension'

SUM({1} {1<Year={'$vMaxYear'}, Date={'<=$vMaxDate'}>}net)

but my table doesn't disregard other selections and value changes if I select any other parameter.

Could someone please tell me what I am doing wrong here?

thanks,

Manoj

Re: Expressions with {1}

Gysbert_Wassenaar — Thu, 06 Nov 2014 18:02:42 GMT

Try this: SUM({1<Year={'$(vMaxYear)'}, Date={'<=$(vMaxDate)'}>}net).

Re: Expressions with {1}

Thu, 06 Nov 2014 18:07:14 GMT

try like this

SUM({1<Year={'$vMaxYear'}, Date={'<=$vMaxDate'}>}net)

Re: Expressions with {1}

Thu, 06 Nov 2014 18:07:42 GMT

if require put end }

Re: Expressions with {1}

Thu, 06 Nov 2014 19:10:46 GMT

I think I know what is happening. My variables (year and dates) are changing with selections causing the values to change. No difference by removing {1} though.

thanks,