Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

want to concatenate two columns as one in qlikview

Hi all,

please suggest how can I merge two columns as one single columns in qlikview

and also ,what condition to use to filter data from two columns in preparing chart?

I want to create waterfall chart and data is in this form

product status category

J            New      ondrug

J             win        off drug

K            new        on drug

K             switch    off drug

I need to concatenate status and category as final status and then create waterfall by looking at the counts of final status' values.

what formula can I use for this.

please advise.

2 Replies
Highlighted

Re: want to concatenate two columns as one in qlikview

Should be like this to concatenate the values

status & ' - ' & category as [final status]

Highlighted
Partner
Partner

Re: want to concatenate two columns as one in qlikview

Hi,

Load some thing like

status&' '&category as [Final_Status]

use & operator to concatenate.