topic Re: Create double pie table in QlikView

Create double pie table

HitcH — Sat, 16 Nov 2024 18:30:43 GMT

Let's make an example:

Year 2018: 3 apples, 3 bananas, 4 strawberries

Year 2019: 1 apple, 2 bananas, 2 strawberries

I'd like to create a double pie table, in 2018 table I want to see 30% apples, 30% bananas, 40% strawberries, in table 2019 I want to see 20% apple, 40% bananas, 40% strawberries.

Setting the expression is np, but I can't find how could I see both tables at the same time.

If I set year as dimension I only get a single pie with 66% 2018 and 33% 2019.

Thanks in advance for any help 🙂

Re: Create double pie table

raji6763 — Wed, 10 Jun 2020 11:22:59 GMT

could you please share your screenshot and expression you used for that chart?

Re: Create double pie table

HitcH — Wed, 10 Jun 2020 14:04:10 GMT

Hi,

Attached the screenshot. I made this using alternative state (and of course this is a possible solution) but I'd like to show the two tables together.

The expressions are all different kind of discounts, so the expressions are:

=sum(disc1)/sum(invoice)

=sum(disc2)/sum(invoice)

...

Re: Create double pie table

HitcH — Thu, 18 Jun 2020 10:04:56 GMT

Is it possible to UPPPP this thread? 🙂