Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Making my Y-axis in percentage.

How do I make my Y-axis in a graph show in percentage, I have seen other post about this, but none is working for me. e.g I have 50 items and 40 meets my selected condition, The Line/Bar Graph should show 80% i.e out of 100%????

1 Solution

Accepted Solutions

Re: Making my Y-axis in percentage.

So no other selection will ever impact this chart except for selection in SLA field? Try this

Count({1<SLA = $:Smiley FrustratedLA>}[TICKET_ID_])/Count({1}TICKET_ID_)

50 Replies

Re: Making my Y-axis in percentage.

May be like this:

Sum(Measure)/Sum({1} Meaure)

Not applicable

Re: Making my Y-axis in percentage.

90c6df7df88645df882d021b8a2e8bf7.png

Hi Sunny, the result is this not as expected.

Re: Making my Y-axis in percentage.

Would you be able to share a sample? Cause images don't really help...

Not applicable

Re: Making my Y-axis in percentage.

The measure TICKET_ID is over 70000 rows and they come in daily, I am trying to sort them out on a monthly, using the RESOLVE_TIME(month) as you see on the X-axis. Only I want is the TICKET_ID showing in percentage not number. what do u mean sample ?? like the below

TICKET_ID   MONTH       CONDITION- SLA MET     SLA Not MET 

70                 JAN                                     50               20

30                 FEB                                     25                5

60                 MAR                                    60                0

20                 APRIL                                  18                2

From that condition above, my Y-Axis should be by MONTH(X-Axis) the following;

60%     -JAN

80%     -FEB

100%   - MAR

89%     -APRIL.

will this help??

Re: Making my Y-axis in percentage.

How do you calculate CONDITION- SLA MET and SLA Not MET? Is this an expression or field?

Not applicable

Re: Making my Y-axis in percentage.

Yes. There is an express. Below is the expression:

IF([TIER]='GOLD',

IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=1,'SLA MET',

IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=1,'SLA MET',

if([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=10,'SLA MET','SLA Not Met')))),

IF([DECODE_PRIORITY]='High' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Urgent' AND [Arrival to Resolve Days]<=3,'SLA MET',

IF([DECODE_PRIORITY]='Medium' AND [Arrival to Resolve Days]<=10,'SLA MET',

IF([DECODE_PRIORITY]='Low' AND [Arrival to Resolve Days]<=20,'SLA MET','SLA Not Met')))))

Which works fine, with the two expected output.

Re: Making my Y-axis in percentage.

I am not sure I am following completely... is there any way you can share your .qvf?

Not applicable

Re: Making my Y-axis in percentage.

The CONDITION - I created using a MASTER with the multiple IF condition in the function expression.

Not applicable

Re: Making my Y-axis in percentage.

And I cant find the option of saving as .QVf file???