how to remove Null in the Pivot

[Samanehsorournejad]

Hi every one,

I have a pivot and in this Pivot I have one Dimension and two Measures and in my Pivot I try to replace null value in my Dimension with -1. I had in Backed Qlik Sense like this Preprogrammed :

view_STORY_POINTS_2:

NullAsValue *;
set Nullvalue=-1;
load Distinct
"ISSUES_ID",
If(IsNull(STORY_POINTS),-1, STORY_POINTS) as STORY_POINTS_2
Resident Fact;

but it steel Show me -1 and '-' . What should I do that I could sum the row of this two Measure :

Stories= count(distinct ISSUES_ID)
Points*Stories = sum(STORY_POINTS_3)

[G3S]

is it perhaps '-' ?

so if you can try: if(isnull(STORY_POINTS) or STORY_POINTS='-', -1,STORY_POINTS) as STORY_POINTS_2

[Samanehsorournejad]

Hi,

and thanks to replay, I had developed it was that you had suggested but the problem is that now it just show me the null value but not these '-' , as you in my previous photo see I had 50458 rows with '-' but now it dose not show them but not sum them with my -1  .

without -with -

could anyone guide me please, if it is True?