Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Adding two rows into single row

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)

2 Replies
Highlighted
Not applicable

Here need to comine N/A and - as Group 1

we show only Group1 in qlikview (sum of two rows (N/A and (blank))) .

Have used like operator not getting desired output

Highlighted
Partner
Partner

- is the null symbol. Replace null values in your data with Group1 and N/A to get the desired result