want to concatenate two columns as one in qlikview

[Anonymous]

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.

[sunny_talwar]

Should be like this to concatenate the values

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

[vishweshwarisun]

Hi,

Load some thing like

status&' '&category as [Final_Status]

use & operator to concatenate.