Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

percent calculation based on a condition

Hi.

another post asking for assistance.

I attach an excel file containing 2 columns: FLD_RESOLUTIONRESOLVEDGROUP and H_CREATORGROUP.


what i am trying to do is calculate the % where the resolved group is the same as the create group. Its for a first time fix rate i am trying to calculate. i think its a basic count where resolved group is equal to create group.


the other rules are:


  • i want to ignore the rows that dont have a resolved group - as these tickets are still open. they shouldn't form any part of the calculation.
  • I need 2 separate % figures - one for 'SMT NMC' group, one for 'SMT M2M Service Desk' group.
  • then an overall % figure for the 2 groups combined where they are the creator group.

in excel, i could easily do this, but am still getting to grips with the format and logic of qlikview.

I need to know whether this is better to put this into a load script to then assign it to a gauge,  or to do it as an expression within the gauge chart properties?

Any assistance would be appreciated

Thanks in advance



1 Solution

Accepted Solutions
Highlighted

Hi,

maybe this helps

QlikCommunity_Thread_234314_Pic2.JPG

QlikCommunity_Thread_234314_Pic1.JPG

QlikCommunity_Thread_234314_Pic3.JPG

LOAD RecNo() as ID,

    FLD_RESOLUTIONRESOLVEDGROUP,

    H_CREATORGROUP

FROM [https://community.qlik.com/servlet/JiveServlet/download/1131511-247273/escalations.xlsx] (ooxml, embedded labels, table is Sheet1);

regards

Marco

View solution in original post

8 Replies
Highlighted

Hi,

maybe this helps

QlikCommunity_Thread_234314_Pic2.JPG

QlikCommunity_Thread_234314_Pic1.JPG

QlikCommunity_Thread_234314_Pic3.JPG

LOAD RecNo() as ID,

    FLD_RESOLUTIONRESOLVEDGROUP,

    H_CREATORGROUP

FROM [https://community.qlik.com/servlet/JiveServlet/download/1131511-247273/escalations.xlsx] (ooxml, embedded labels, table is Sheet1);

regards

Marco

View solution in original post

Highlighted
Contributor II
Contributor II

ok, i got this working but when i select a different date (based on when a ticket was created), the gauge moves to and stays at 97% no matter which month i use. The overall % is 90% for all rows in the spreasheet, which of course is correct.

Just to give you more info - i only extracted a limited set of data attached to this query, but if you can imagine there is a create date associated with each row, this is what i would like to filter on to get a % for that month.

hopefully that gives you enough info to assist me further?

Highlighted

please post a sample app including some (mock up) data and your expected result.

thanks

regards

Marco

Highlighted
Contributor II
Contributor II

Hi Marco,

i managed to get it working.

Thank you very much. The only thing i am struggling with is getting the % figure to appear in the bottom middle of the chart - as per yours.

I can get the % figure to display, but it appears in the top right of the chart. looks unsightly.

Any advice?

Thanks

Highlighted

Hi,

I used the "text in chart" function to generate the percentage figure.

You can reposition it by holding CTRL+Shift and dragging the red square containing the figure to another place:

QlikCommunity_Thread_234314_Pic4.JPG

QlikCommunity_Thread_234314_Pic5.JPG

hope this helps

regards

Marco

Highlighted
Contributor II
Contributor II

i didnt know about the CTRL+Shift function - this has solved my problem.

once again, thank you for your assistance

Highlighted
Not applicable

thank you for sharing the answer. very help ful for learning

Highlighted

you're welcome.

Glad it helped

regards

Marco