Null value error in chart

[Chandra_Shekar]

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

[BrunPierre]

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

[Chandra_Shekar]

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

[BrunPierre]

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