Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

abhinayranjan11
New Contributor III

Null handling in front end for multiple expression and single dimension

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.

1 Solution

Accepted Solutions
abhinayranjan11
New Contributor III

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

yes that should come 0

8 Replies

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

You are looking for something like this?

Capture.PNG

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

abhinayranjan11
New Contributor III

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

rfimage.PNG

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

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

abhinayranjan11
New Contributor III

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

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

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

abhinayranjan11
New Contributor III

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

Rfoutput.PNG

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

So you want to see 0 in these two locations?

Capture.PNG

Is that the issue?

abhinayranjan11
New Contributor III

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

yes that should come 0

Community Browser