topic Re: Null value error in chart in App Development

Null value error in chart

Chandra_Shekar — Mon, 29 Aug 2022 06:57:59 GMT

There are 4 filters
BG >> IOU >> Sub IOU >> Group Client
for some of the IOUs, there is no BG name and for some of the sub IOUs there is no IOU name and BG name
So in the Load script I have included

if(BG='','Others',BG) as BG,
if("IOU_NAME"='','Others',"IOU_NAME") as "IOU_NAME"

There is a barchart, with dropdown as dimension and some respective measure
If we selecting any IOU in the filter where there is no BG name, it is drilling up to BG and showing with Others in x-axis and showing the value but it has to drill down to sub IOU level, similar case with sub IOU

Re: Null value error in chart

BrunPierre — Mon, 29 Aug 2022 08:49:57 GMT

Do you get all the string values when you display IOU_NAME for instance in a List Box?

If not, It may well be that they are not actually null but spaces among others, so I'd suggest you use these combinations.

IF(Len(trim(BG))= 0 or BG=' ' or BG='-', 'Others',

IF(Len(trim(IOU_NAME))= 0 or IOU_NAME=' ' or IOU_NAME='-',' Others',IOU_NAME )) as IOU_NAME

Re: Null value error in chart

Chandra_Shekar — Mon, 29 Aug 2022 08:42:04 GMT

Actually ,It has to be drill down to next level.. like if we select IOU where this IOU doesnot have BG name, it has to drill down to sub IOU but it is coming back to BG

Re: Null value error in chart

BrunPierre — Mon, 29 Aug 2022 09:12:58 GMT

It would be useful to see what you're getting and what is expected.