Making my Y-axis in percentage.

[#1]

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

[#2]

A 100% and if it is possible. can the chart only react when the SLA MET/SLA NOT MET is clicked and nothing ?

[sunny_talwar · Accepted solution]

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_)

[#4]

Hi Sunny T,

    It is solved, what if I want other selection to affect, what do I take off, just in case???

[#5]

Thank you very much. I really appreciate!!!

[sunny_talwar]

Just use this

Count([TICKET_ID_])/Count({<SLA>}TICKET_ID_)

Also, if I may ask, would you consider marking helpful response (in addition to the correct response) so that people landing on this huge thread can look for responses which might help them troubleshoot a similar issue. You can mark as many response as you want as helpful, but I would not overdo to make sure that only responses which are really helpful to other users are marked.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[#7]

Will do it now. Thanks Thanks thanks!! cant be happy enough

[Anil_Babu_Samineni]

Good Long stalwar1‌ Bhai. Happy to learn few things from this Queue post

[#9]

Hello Sunny T,

    thanks for the help, it was a huge success in my team, due to its success other teams has asked me to do a more bigger APP foe the whole of the company. going from the below code, which u altered and I ran in my script;

LOAD *,

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'))))) as SLA;

I wanna add another TIER to the IF statement, instead of having just GOLD and SILVER  Tier, I wanna to add BRONZE to it, with its conditions too. I did the following;

LOAD *,

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([TIER]='SILVER',

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'))))),

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

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

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

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

but this doesn't seem to work. Can you help me out please?

[sunny_talwar]

Try this, I think you had an extra parenthesis:

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([TIER]='SILVER',

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')))),

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

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

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

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

[#11]

how silly I'm I. Thanks, its working.