topic Re: Null values in set analysis in QlikView

Null values in set analysis

Thu, 12 Mar 2015 20:43:29 GMT

Hi all,

I'm looking for null handling in set analysis.

I have gone through many threads though, couldn't find an appropriate solution.

Here is what i'm looking for.

sum({<[Month]={'<=$(=max([Month]))'}>}[SALES])

This will do an YTD calculation. But for some months i have sales value as null (). so i dont see any accumulated sales value for that country.

I tried something like below already, that's not working out.

sum({<[SALES]={*},[Month]={'<=$(=max([Month]))'}>}[SALES])

Thanks in advance.

MK_QSL — Thu, 12 Mar 2015 20:49:06 GMT

Can you provide sample data please?

Thu, 12 Mar 2015 21:41:50 GMT

try "show zero" in presentation tab

Thu, 12 Mar 2015 23:55:26 GMT

Try,

In Presentation tab,

1. Uncheck 'Suppress zero-Values'

2.Check-In 'Zero On-bars'

Regards

Lathaa

sunny_talwar — Fri, 13 Mar 2015 01:08:59 GMT

This might help:

Sum({<[SALES]={'*?'},[Month]={'<=$(=max([Month]))'}>}[SALES])

I have found out that only * doesn't seem to remove null, but '*?' does. Give it a try, may be it solves your issue.

HTH

Best,

Fri, 13 Mar 2015 02:57:47 GMT

My suggestion is remove the null's in script level only that will be best practices

load

resident Table1 where sales>=0;

try this

thanks

Manju