topic Set Expression Error in QlikView

Set Expression Error

Wed, 02 May 2012 12:10:40 GMT

I have used the following set expression to calculate my value and made it free from ZIP, Name and Territory selection by passing ZIP=, Name=, TERRITORY= (i.e. Null Values) but still if i am making any selection in ZIP, Name and Territory the value of my expression is changing. What could be the reason.

sum({$<%EPID={1},Segment={'Advocates'},ZIP=, Name=, TERRITORY=>} (eTRx_Volume))/sum( {$<%EPID={7},Segment={'Advocates'}, ZIP=, Name=, TERRITORY=>} (eTRx_Volume)

My Expression is

Set Expression Error

Wed, 02 May 2012 12:21:56 GMT

Try with isnull(ZIP), isnull(TERRITORY).. instead of ZIP=,TERRITORY=

Swapnil

Set Expression Error

Wed, 02 May 2012 12:26:09 GMT

How do u write Isnull in Set Expression. I am trying

sum({$<%EPID={1},Segment={'Advocates'}, Isnull(ZIP), Isnull(Name), Isnull(TERRITORY)>}

but this is giving me an error

Set Expression Error

jagannalla — Wed, 02 May 2012 12:49:53 GMT

No it should work perfectly according to your expr. Can you share your sample file so it helps us to look on it.

Set Expression Error

SunilChauhan — Wed, 02 May 2012 12:54:17 GMT

use below code

sum({<%EPID={1},Segment={'Advocates'},ZIP=, Name=, TERRITORY=>} (eTRx_Volume))/sum( {<%EPID={7},Segment={'Advocates'}, ZIP=, Name=,TERRITORY=>} (eTRx_Volume) )

hope this helps

Set Expression Error

Wed, 02 May 2012 12:57:49 GMT

I am using the same expression but it is not working.

Set Expression Error

SunilChauhan — Wed, 02 May 2012 13:00:12 GMT

can you attached a sample file

??????