topic IsNull Syntax in QlikView

IsNull Syntax

Thu, 03 May 2012 06:16:19 GMT

I want to use Isnull in this set expression:

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

instead of ZIP=, Name=, TERRITORY=

what is the proper syntax for this ?

IsNull Syntax

kaushiknsolanki — Thu, 03 May 2012 06:30:05 GMT

Hi Sumit,

When you use Zip=, Name=, Territory = in set analysis, this doesnt mean you are taking null values from this field. This statement means do not consider any selection made in this fields i.e Zip,Name and Territory.

I hope the idea is clear, if not please elobrate in details.

Regards,

Kaushik Solanki

IsNull Syntax

Thu, 03 May 2012 06:40:03 GMT

I know that but in this case that condition is not working. If i am making selection in Zip, name or Territory.. it is changing the value of the expression. I dont know why ??

IsNull Syntax

kaushiknsolanki — Thu, 03 May 2012 06:43:33 GMT

Hi,

Will you please share the sample application.

Regards,

Kaushik Solanki

IsNull Syntax

Thu, 03 May 2012 07:04:28 GMT

Actuallu my application is very huge in size. so i cant upload the file

IsNull Syntax

kaushiknsolanki — Thu, 03 May 2012 07:06:19 GMT

Hi,

Can you try to create a sample application to show this problem.

Cause unless we see what you are doing, we wont be able to solve this.

Regards,

Kaushik Solanki

IsNull Syntax

Thu, 03 May 2012 08:27:36 GMT

sum({$ <Dimension=>} Field)

--> will give the sum of "Field", not considering the "Dimension" selection (as if all values of "Dimension" were possible).

sum({$ <Dimension={}>} Field)

--> will give the sum of "Field", not considering the "Dimension" selection but filtering only on lines where "Dimension" is null / empty.