Discussion board where members can get started with QlikView.
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.
Should be like this to concatenate the values
status & ' - ' & category as [final status]
Load some thing like
status&' '&category as [Final_Status]
use & operator to concatenate.