Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stuhico09
Creator
Creator

How can I display result which is greater than 0?

Dear Friend,

My result display value which include 0 & negative. how to modified my formula to exclude it? Thanks.

Have a nice day 🙂

=Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*$<[SR No]-={"''"}>

*$<[Gate]={"Gate C"}>

}

(Gate))-count([SR No])

1 Solution

Accepted Solutions
stuhico09
Creator
Creator

Dear All,

Correct answer as below. Thanks.

sum(Aggr(



if(


(Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>


*$<[SR No]-={"''"}>


*$<[Gate]={"Gate C"}>



}(Gate))-count([SR No]))>0,




(Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>


*$<[SR No]-={"''"}>


*$<[Gate]={"Gate C"}>



}(Gate))-count([SR No])),




'No repetition') , [SR No]))


ssd.PNG

View solution in original post

6 Replies
_armoco_
Partner
Partner

Put the expression in a variable and use an if condition?

if($(your variable)>0, $(your var), 'val have 0's and negative')

stuhico09
Creator
Creator

Hi Arjun,

I manage to get the display in table. but how im gonna show the total in KPI object? it showing NaN.Could be due to the text. it should  show 8 instead of NaN.

if(

(Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*$<[SR No]-={"''"}>

*$<[Gate]={"Gate C"}>

}(Gate))-count([SR No]))>0,

(Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>

*$<[SR No]-={"''"}>

*$<[Gate]={"Gate C"}>

}(Gate))-count([SR No])),

'No repetition')

kpi.PNG

tablekpi.PNG

agigliotti
Partner
Partner

i think you'll need an aggr function to achieve it.

OmarBenSalem
Partner
Partner

change your expression

from;

YourMeasure

to:

if (YourMeasure>0, YourMeasure, 0)

and under add-on, uncheck : show zro values.

OmarBenSalem
Partner
Partner

in a KPI, try sthing like:

sum({<Yourdim={"=sum(YourMeasure)>0"}>}YourMeasure)

stuhico09
Creator
Creator

Dear All,

Correct answer as below. Thanks.

sum(Aggr(



if(


(Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>


*$<[SR No]-={"''"}>


*$<[Gate]={"Gate C"}>



}(Gate))-count([SR No]))>0,




(Count({$<[SR No]={"=Min ({<Temp = {'Task_1'}>}[Date Created]) >=  MakeDate(2018,1,15)"}>


*$<[SR No]-={"''"}>


*$<[Gate]={"Gate C"}>



}(Gate))-count([SR No])),




'No repetition') , [SR No]))


ssd.PNG

View solution in original post