topic Re: Include null value in set analysis in QlikView

Include null value in set analysis

Thu, 18 Jul 2013 08:06:17 GMT

Hi,

I've created a variable, vMyValue, which contain all the values that i need to compare in my analysis.

My analysis would be something like this:

Sum({<BUD_UNBUD={$(vBudgetConfig)}>}TotalBudget)

My question is I want to compare if the BUD_UNBUD = 'Budgeted' and null, then it will proceed to sum. How should I include the "Null" value in my variable?

Thanks.

Eugene

Re: Include null value in set analysis

tresB — Thu, 18 Jul 2013 08:13:40 GMT

try:

Sum({<BUD_UNBUD={$(vBudgetConfig) , '' }>}TotalBudget)

Re: Include null value in set analysis

kaushiknsolanki — Thu, 18 Jul 2013 09:55:47 GMT

Hi,

The best way for this is you give a value to null values.

Something like this.

Load Field1, If(Isnull(Field2,'NULL',Field2)) as Field2 from xyz.

Then you can just use the NULL in search to get the null data.

Regards,

Kaushik Solanki

Re: Include null value in set analysis

er_mohit — Thu, 18 Jul 2013 09:57:55 GMT

try this

Sum({<BUD_UNBUD={$(vBudgetConfig),'',' ','-'}>}TotalBudget)

Re: Include null value in set analysis

Fri, 19 Jul 2013 01:21:23 GMT

why i never think of this? hee. thank you.