topic Re: Chart Displaying Nulls Set analysis in QlikView

Chart Displaying Nulls Set analysis

qlikofba — Wed, 28 Jun 2017 17:29:49 GMT

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

Re: Chart Displaying Nulls Set analysis

Anil_Babu_Samineni — Wed, 28 Jun 2017 17:35:29 GMT

May be this?

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

Re: Chart Displaying Nulls Set analysis

qlikofba — Wed, 28 Jun 2017 17:46:36 GMT

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

Re: Chart Displaying Nulls Set analysis

sunny_talwar — Wed, 28 Jun 2017 17:51:24 GMT

May be this

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

Re: Chart Displaying Nulls Set analysis

Anil_Babu_Samineni — Wed, 28 Jun 2017 17:51:32 GMT

May be this?

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

Re: Chart Displaying Nulls Set analysis

qlikofba — Wed, 28 Jun 2017 18:20:44 GMT

it is saying there is an error in this expression

Re: Chart Displaying Nulls Set analysis

sunny_talwar — Wed, 28 Jun 2017 18:22:34 GMT

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

Re: Chart Displaying Nulls Set analysis

qlikofba — Wed, 28 Jun 2017 18:52:42 GMT

This works, THank you very much.