Creating a script function that also returns NULL

Fri, 12 Jun 2015 13:14:00 GMT

Hi,

In my model I try to create a variable that contains a formula that returns the content from a table given a current selection, but i also want it to return the NULL (blank) value when the cell is blank.

Now, my script looks like this:

let vVariable = 'sum({$<KV_Start_Date = {"< =' & ' $ ' & ' (=min(Date))"}>} KV_Actual_Value)

In practice, the data table containing KV_Value_Actual only have one cell for each selection. Thus, I'm actually only trying to get the content of the cell in the table returned by the function.

I find that the "sum" function returns blank cells as 0, not Null().

This is an example of the content I want the formula to return:

Selection	KV_Value_Actual	What I want the formula to return
A	100	100
B	50	50
C
D	0	0

Appreciate all help

Re: Creating a script function that also returns NULL

swuehl — Fri, 12 Jun 2015 13:17:29 GMT

Try the only() function instead of sum()

let vVariable = 'only({$<KV_Start_Date = {"< =' & ' $ ' & ' (=min(Date))"}>} KV_Actual_Value)

topic Creating a script function that also returns NULL in QlikView

Creating a script function that also returns NULL

Re: Creating a script function that also returns NULL