topic Re: Null handling in front end for multiple expression and single dimension in QlikView

Null handling in front end for multiple expression and single dimension

abhinayranjan11 — Wed, 06 Sep 2017 12:59:00 GMT

Hello All,

I am facing an issue in front end the users need that null for trip id 305 and 317 should be suppressed but since null is there for trip id 301 its k for this as boxes are not there for all location but if boxes gets empty in between the location before 6 its throwing null.Users don't need these nulls trip id can be anything.Pivot location wise weight variation of boxes.I am attaching the application here if anyone have opinion please comment and solve .Thanks.

Re: Null handling in front end for multiple expression and single dimension

sunny_talwar — Wed, 06 Sep 2017 13:08:31 GMT

You are looking for something like this?

Use this as your calculated dimension for Box and make sure to select 'Suppress When Value Is Null' on the dimension tab for Box dimension

=If(Len(Trim(ItemName)) > 0, ItemName,

If(Aggr(Count(TOTAL <TripID, VName, Time_Stamp> ItemName), TripID, VName, Time_Stamp, ItemName) = 0, Dual('-', 1)))

Re: Null handling in front end for multiple expression and single dimension

abhinayranjan11 — Wed, 06 Sep 2017 13:13:18 GMT

only for these two in this app not for all means not for trip id 301

Re: Null handling in front end for multiple expression and single dimension

sunny_talwar — Wed, 06 Sep 2017 13:14:39 GMT

only for these two in this app not for all means not for trip id 301

huh?? Sorry, but I have no idea what you mean...

Re: Null handling in front end for multiple expression and single dimension

abhinayranjan11 — Wed, 06 Sep 2017 14:09:24 GMT

I mean to say null should be suppressed for trip id 305 and 317 but the expected weight and actual weight for these two trip id i.e Expected weight_loc3 and Actual Weight the 0 should not suppress , Expected weight_loc6 and Actual Weight the 0 should not suppress.on suppressing null by using dimension as expression u hv mentioned the ExpectedWeight_Loc3 ,ExpectedWeight_Loc6 the 0 should show on these location.As the empty truck move to these location so itemname(box) should come 0 for this in a single line.

Re: Null handling in front end for multiple expression and single dimension

sunny_talwar — Wed, 06 Sep 2017 15:09:50 GMT

I have no idea what you are looking to get... can you show me the expected output in an Excel file?

Re: Null handling in front end for multiple expression and single dimension

abhinayranjan11 — Wed, 06 Sep 2017 15:24:41 GMT

Re: Null handling in front end for multiple expression and single dimension

sunny_talwar — Wed, 06 Sep 2017 15:42:24 GMT

So you want to see 0 in these two locations?

Is that the issue?

Re: Null handling in front end for multiple expression and single dimension

abhinayranjan11 — Wed, 06 Sep 2017 16:01:21 GMT

yes that should come 0