topic Stacked Bar Chart in QlikView

Stacked Bar Chart

Zaga_69 — Sat, 16 Nov 2024 04:43:51 GMT

Hi all!

I am struggling to create a 100 Percent Stacked Bar in Qlik sense

I have tried the following set expression:

count(Ticket_SID)/

count(total <[Interface Type]>Ticket_SID)

Seems to be the formula is not working properly, since it does not calculate the % of each member of my dimension (i.e. Interface Type)

Any idea what is wrong?

Thanks,

Edi

sunny_talwar — Thu, 17 Jan 2019 13:05:23 GMT

Try this

Count(Ticket_SID)/
Count(TOTAL <[Creation Year]>Ticket_SID)

Zaga_69 — Thu, 17 Jan 2019 13:21:42 GMT

Hi Sunny!

Thanks it works.

Do you know how I can put the labels into each bar?

What Qlik does is only to put the 100% label.

many Thanks again, it is really appreciate.

Best regards.

Edi

sunny_talwar — Thu, 17 Jan 2019 13:26:13 GMT

I am not really sure about that part.