Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
attaching the xls file
Hi Dani,
Something like this?
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
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