Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

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
MVP
MVP

Re: Sum Logic

May be this

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

11 Replies
rammuthiah
Contributor II

Re: Sum Logic

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

MVP
MVP

Re: Sum Logic

if you only want OK status, with set analysis

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

rammuthiah
Contributor II

Re: Sum Logic

I need both Status

MVP
MVP

Re: Sum Logic

if(Dimensionality()=0,

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

sum(Value))

1.png

MVP
MVP

Re: Sum Logic

May be this

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

rammuthiah
Contributor II

Re: Sum Logic

Thank you Sunny.

rammuthiah
Contributor II

Re: Sum Logic

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

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

MVP
MVP

Re: Sum Logic

In a new column? May be this

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

rammuthiah
Contributor II

Re: Sum Logic

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?

Community Browser