Discussion board where members can get started with QlikView.
we Have a data (N/A,n/a,1,2,3,4)Group1 (sum of N/A and (blank) rows)
we show only Group1 in qlikview (sum of two rows (N/A and (blank))) .
=if(Queue like ('N/A'),'Group1',Queue)
Here need to comine N/A and - as Group 1
Have used like operator not getting desired output
- is the null symbol. Replace null values in your data with Group1 and N/A to get the desired result