topic Re: Column bar with positive & negative columns in QlikView

Column bar with positive & negative columns

danialier — Tue, 21 Apr 2015 07:20:21 GMT

Hello,

I want to create a bar chart showing the "active" as positive bars and the "abandoners" as negative bars (see excel attached). That would be two columns per month showing "users" and "companies":

> users: one positive bar per month for active users and in the same bar, one negative bar per month for abandoners users

> companies: one positive bar per month for active companies and in the same bar, one negative bar per month for abandoners companies

Please help.

Thanks,

dani

Re: Column bar with positive & negative columns

danialier — Tue, 21 Apr 2015 07:23:04 GMT

attaching the xls file

Re: Column bar with positive & negative columns

Anonymous — Tue, 21 Apr 2015 08:09:32 GMT

Hi Dani,

Something like this?

Re: Column bar with positive & negative columns

danialier — Tue, 21 Apr 2015 10:24:34 GMT

Not really... X axis should be the month, while columns should be the user & company. Then in Y axis should be the active (in positive) and abandoners (in negative).

Thanks,

dani

Re: Column bar with positive & negative columns

marcus_malinow — Tue, 21 Apr 2015 10:45:48 GMT

Having taken ij qlik's document, I modified the chart to hopefully give you what you're looking for.

Dimensions are Month and F2 (companies and users).

One expression for active and one for abandoners.

Chart Style Subtype set to stacked.

Marcus