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.
