Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

6 Replies
swuehl
MVP
MVP

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

See attached.

Not applicable
Author

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
Author

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

Hope this helps.

Regards

Mhatim

Not applicable
Author

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
Author

Hi,

Or you can try this one if you like.

Regards,

Janzen

Not applicable
Author

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