Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to get a combi chart with 2 dimensions?? Excel can do it... :-(

Dear all,

I have a real life case in which I want to combine sales data per product per year with the sales target per year. Nothing special I would say...

See attached Excel file and QVW... I don't think this is possible in QV?!

Maybe I have to set up my data differently?

Please help!

Regards,
Marcel Artz

Tags (1)
6 Replies
MVP
MVP

Re: How to get a combi chart with 2 dimensions?? Excel can do it... :-(

If you can create an expression per measure, you can recreate the Excel chart.

See attached.

Not applicable

Re: How to get a combi chart with 2 dimensions?? Excel can do it... :-(

Yes, that would be an option if the number of products wasn't flexible and over 25 products.

Any other options?

Regards,

Marcel

Not applicable

Re: How to get a combi chart with 2 dimensions?? Excel can do it... :-(

Although not as per requirement however you can have a look.

Hope this helps.

Regards

Mhatim

Not applicable

Re: How to get a combi chart with 2 dimensions?? Excel can do it... :-(

Hi Mhatim,

Thank you for the additional information, but as you already said, not quite the complete answer. Thanks for your help!

Regards,
Marcel

Not applicable

Re: How to get a combi chart with 2 dimensions?? Excel can do it... :-(

Hi,

Or you can try this one if you like.

Regards,

Janzen

Not applicable

Re: How to get a combi chart with 2 dimensions?? Excel can do it... :-(

Thanks Janzen,

These are all work-a-rounds for something that is basic functionality in other tools. I'll pass this one on as an idea for development.

Thanks for your help!

Regards,
Marcel

Community Browser