Discussion board where members can get started with Qlik Sense.
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
still am unable to select . can anyone have this issue?
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
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.
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
adding same in master item resolved my issue
removed the aggr .