Flag in chart,, expression

[everest226]

HI

i have created dual flag   for 2 field ,

1 order given   Yes or no

2 Order deliver  yes or no

And created a 2 column name in chart name Order given   order taken but was unable to show yes or no in row  ,it also has ID number column.

stalwar1‌

@

[MarcoWedel]

please post a sample application to test with.

thanks

regards

Marco

[girirajsinh]

It seems your flag fields are generating NULL in the chat. They clearly have value 'Y' and 'N' in the filters.

It would be interesting to see how you generate those flag fields.

In case your date fields are having null for no value,

try

if(IsNull(ORDER_DATE),'N','Y') as ORDERED_FLAG,
if(IsNull(ORDER_DELIVER),'N','Y') as DELIVERED_FLAG

Or if they are not null try generating flags with

if(len(ORDER_DATE)=0,'N','Y') as ORDERED_FLAG,
if( len(ORDER_DELIVER)=0,'N','Y') as DELIVERED_FLAG

This were still on assumptions so please share your calculations.