Exclude zero values on each columns in Table.

[Rajesh]

Hi All,

I am trying to create a Table in that 

Dim: Workflow name, Sessionname

Measurea (Duration) : =Sum({<Duration = {">20"},Date={"$(=Date(Today()-3,'MM/DD/YYYY'))"}>}Duration)

                                            Sum({<Duration = {">20"},Date={"$(=Date(Today()-2,'MM/DD/YYYY'))"}>}Duration)

                                          Sum({<Duration = {">20"},Date={"$(=Date(Today(),'MM/DD/YYYY'))"}>}Duration)

displaying data for current and previous day and day before yesterday

but i am getting Zero(0) values for some columns

Please see below screenshots for reference

Need Out put like below

Kindly Can any one suggest how can i get this output.

Thanks,

Rajesh.

[tresesco · Accepted solution]

You can write your expressions like:

 If(RangeMin(Exp1, Exp2, Exp3)>0, Exp1)

 If(RangeMin(Exp1, Exp2, Exp3)>0, Exp2)

 If(RangeMin(Exp1, Exp2, Exp3)>0, Exp3)

[Rajesh]

Thanks for reply Tresesco,

But my requirement is changed

Can you look in to another below thread for that.

https://community.qlik.com/t5/New-to-Qlik-Sense/Need-to-find-Previous-days-Duration-based-on-Current...

Regards

Rajesh

[tresesco]

If your requirement has changed, please close this thread by 'Like'ing and/or accepting reply as solution.

[Rajesh]

Thank you Tresesco,

Can you look into mentioned another thread.

Regards

Rajesh