Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Chanty4u
Esteemed Contributor III

unable to select Null

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

Tags (1)
6 Replies

Re: unable to select Null

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
Esteemed Contributor

Re: unable to select Null

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
Contributor

Re: unable to select Null

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
Esteemed Contributor III

Re: unable to select Null

No sunny  in script i cannot do in script.

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

Re: unable to select Null

Super

Chanty4u
Esteemed Contributor III

Re: unable to select Null

adding same in master item resolved my issue

removed the aggr .

Community Browser