topic Flag in chart,, expression in QlikView

Flag in chart,, expression

everest226 — Sat, 14 Jan 2017 00:21:35 GMT

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.

MarcoWedel — Sat, 14 Jan 2017 01:35:32 GMT

please post a sample application to test with.

thanks

regards

Marco

girirajsinh — Sat, 14 Jan 2017 10:57:50 GMT

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.