Column bar with positive & negative columns

[danialier]

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

[danialier]

attaching the xls file

[Anonymous]

Hi Dani,

  Something like this?

[danialier]

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

[marcus_malinow · Accepted solution]

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