unable to select Null

[Chanty4u]

Hi all,

i have a chart  with dimension   group

so in that i have a null values  so the bar is showing with nulls but i m unable to select that ?

the dimension is coming from two tables .

i tried below  

=aggr(if(isnull(Group),'Un',Group),Group)

still am unable to select . can anyone have this issue?

best

chanty

[sunny_talwar]

May be bring them as white spaces from the back end in another field.... or do this in the script

if(isnull(Group),'Un',Group) as New_Group

[datanibbler]

Hi,

you cannot select "nothing" - that is just not possible in QlikView (which I know) and presumably in QlikSense. You have to create some value for those empty fields using some IF_construct - you can only select data.

Best regards,

DataNibbler

[JordyWegman]

Use this formula to see where the Null() values are: IF(Trim(FIELD & '') = '', 'Unknown', FIELD) and replace them with maybe Group if you need.

[Chanty4u]

No sunny  in script i cannot do in script.

its done sunny.     i added master dimension and its working fine  thanks

[sunny_talwar]

Super

[Chanty4u]

adding same in master item resolved my issue

removed the aggr .