Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

Sum Logic

I actually getting total as 30. Is there any way to show as 15, based on Date.

Date

Value

status

9/13/2017

5

OK

9/13/2017

5

NOK

9/14/2017

5

OK

9/14/2017

5

NOK

9/15/2017

5

OK

9/15/2017

5

NOK

Total

15

1 Solution

Accepted Solutions
sunny_talwar

May be this

If(Dimensionality() = 0, Sum({<status = {OK}>} Value), Sum(Value))

View solution in original post

11 Replies
rammuthiah
Creator III
Creator III
Author

For the Date 09/13/2017 -  value is 5

                   09/14/2017 -  value is 5

                   09/15/2017 -  value is 5, So the Total - 15

maxgro
MVP
MVP

if you only want OK status, with set analysis

sum({$ <status={OK}>} Value)

rammuthiah
Creator III
Creator III
Author

I need both Status

maxgro
MVP
MVP

if(Dimensionality()=0,

sum(aggr(sum(DISTINCT Value), Date)),

sum(Value))

1.png

sunny_talwar

May be this

If(Dimensionality() = 0, Sum({<status = {OK}>} Value), Sum(Value))

rammuthiah
Creator III
Creator III
Author

Thank you Sunny.

rammuthiah
Creator III
Creator III
Author

Also, I need the difference for Value based on Date,

For 09/13/2017 & 09/14/2017, tghe difference is 0(Zero).

sunny_talwar

In a new column? May be this

Aggr(Sum(Value) - Above(Sum(Value)), status, Date)

rammuthiah
Creator III
Creator III
Author

But my requirement,

If the value for 09/13/2017 - 5

and the value for 09/13/2017 - 6. The difference is 1 and it is higher than the previous date. Is there any way to highlight the difference by symbol like (^ or v) increased/decreased?