Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Use this formula to see where the Null() values are: IF(Trim(FIELD & '') = '', 'Unknown', FIELD) and replace them with maybe Group if you need.
No sunny in script i cannot do in script.
its done sunny. i added master dimension and its working fine thanks
Super
adding same in master item resolved my issue
removed the aggr .