Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

johnsmithqv
New Contributor III

stacked bar in qliksense

     Hi all,

I would need help on the stacked bar chart in qliksense.

I have 3 columns of data i.e Department, Revenue Original, Revenue Estimated.

Now i have to calculate revenue ratio i.e revenue original / revenue estimated -

who calculate the percentage (revenue original/revenue estimate) / total of both sum and if the ratio is <1 make it revenue failure if not revenue failure.

and we need to count the number of revenue failure and revenue pass percentage.

those percentage graph should be on bar chart .

Ex is attached in the image and source spread sheet is also attached - please help me out

9 Replies
johnsmithqv
New Contributor III

Re: stacked bar in qliksense

any help please

omarbensalem
Esteemed Contributor

Re: stacked bar in qliksense

sthing like this?

Capture.PNG

or sthing like this:

Capture.PNG

johnsmithqv
New Contributor III

Re: stacked bar in qliksense

Second style but inside the bar percentages are needed- can you please share it

omarbensalem
Esteemed Contributor

Re: stacked bar in qliksense

You cannot have the percentage inside of the bars in the native bar chart of qlik.. maybe an extension would allow it (see this one : Qlik Branch )

as for the expressions used:

dim:

Department

measures:

Sum([Revenue Original]) / (sum({<Department>}[Revenue Estimated])+sum({<Department>}[Revenue Original]))


Sum([Revenue Estimated]) / (sum({<Department>}[Revenue Estimated])+sum({<Department>}[Revenue Original]))

omarbensalem
Esteemed Contributor

Re: stacked bar in qliksense

have u tried using the 2 expressions?

johnsmithqv
New Contributor III

Re: stacked bar in qliksense

yes but the logic i need is count of % <1 and count of % >1
i need to have those

johnsmithqv
New Contributor III

Re: stacked bar in qliksense

any help please

johnsmithqv
New Contributor III

Re: stacked bar in qliksense

suggestions please

omarbensalem
Esteemed Contributor

Re: stacked bar in qliksense

maybe

count({<Department={"=(Sum([Revenue Original]) / sum([Revenue Estimated]))>1"}>}Department)

count({<Department={"=(Sum([Revenue Original]) / sum([Revenue Estimated]))<=1"}>}Department)