Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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)))
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.