Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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

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

View solution in original post

50 Replies
sunny_talwar

May be like this:

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

Not applicable
Author

90c6df7df88645df882d021b8a2e8bf7.png

Hi Sunny, the result is this not as expected.

sunny_talwar

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

Not applicable
Author

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??

sunny_talwar

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

Not applicable
Author

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.

sunny_talwar

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

Not applicable
Author

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

Not applicable
Author

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