Chart Displaying Nulls Set analysis

[qlikofba]

Hi, I have a pivot table showing a list of

Names and then their sales amount

               6/24/2017    |   6/23/2017

John        10                     -

Joe          11                    10

Tim         -                    5

The dimensions are name, and date(across top)

with   an expression of    Sum({$<sales={">$(=3)"}>}sales)

I believe the nulls are showing because their sales are less than 3. Is there anyway to hide the - columns so only Joes row will be showing?

Thanks

[Anil_Babu_Samineni]

May be this?

Sum({$<sales={'>=3'}>}sales)

[qlikofba]

Thank didn't seem to do it. Still some - showing.

[sunny_talwar]

May be this

If(Sum(TOTAL <name> Aggr(If(Sum({$<sales={">$(=3)"}>}sales) > 3, 1, 0) = Count(TOTAL DISTINCT date), Sum({$<sales={">$(=3)"}>}sales))

[Anil_Babu_Samineni]

May be this?

Sum({$<sales={"=Sum(sales) >= 3"}, sales -= {'-'}>}sales)

[qlikofba]

it is saying there is an error in this expression

[sunny_talwar · Accepted solution]

My bad, try this

If(Sum(TOTAL <name> Aggr(If(Sum({$<sales={">$(=3)"}>}sales) > 3, 1, 0), name, date)) = Count(TOTAL DISTINCT date), Sum({$<sales={">$(=3)"}>}sales))

[qlikofba]

This works, THank you very much.