topic Two stacked expressions on a chart with two dimensions in QlikView

Two stacked expressions on a chart with two dimensions

eugeniyaromanov — Wed, 25 Nov 2020 16:16:04 GMT

Hello, everyone!

I need help.

Actually, I need to know if Qlik can do it. And if so - i need help

Plz see the attachment below.

Now the data:

I have a table with number, country, date and cost.

I need to calculate how much I've spend for every country in a period, and to count.

Basically i need to sum and to count in two dimensions.

But I need to do it with stacked bar chart.

For 1 expression this is easy:

And the question:

Can I put it into one chart?

Like this:

Thanks in advance!

sunny_talwar — Mon, 06 Nov 2017 12:51:04 GMT

This would be the closest you might be able to get

eugeniyaromanov — Mon, 06 Nov 2017 12:58:34 GMT

Sunny, as always, you're the best!

Going to try on original data