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: 
cbaqir
Specialist II
Specialist II

Rename Class and Specify Buckets

Right now I am using the following Dimension for my interval buckets:

=replace(aggr(Class(count(GOV_DECISION_BODY_SUB),2), DEFECT_ID), '<= x <','-')

What I am trying to accomplish is 3 things:

  1. Hardcode the PROCESS_STEP selections so the user does not need to select them from the list box. I will have several versions of this graph with different selections to be used in an Nprinting export.
  2. I would think 0-1, 2-3, 4-5, 6 or more or whatever a frequency distribution suggests. Or, maybe 0, and 1 should be broken out separately. . . . and then the other categories.
  3. If possible, rename the 0-1 bucket to Low Complexity, rename 2-3 to Medium etc

11-1-2017 9-59-04 AM.jpg

Any suggestions?

Thanks in advance!

stalwar1

35 Replies
cbaqir
Specialist II
Specialist II
Author

Awesome!! Thank you! How do I change the sort order for the Legend?

sunny_talwar

Just the legend or the bars also? What order do you want?

cbaqir
Specialist II
Specialist II
Author

And what about hard coding the selections? Any ideas?

cbaqir
Specialist II
Specialist II
Author

both..if possible, in numerical order?

11-1-2017 10-48-56 AM.jpg

sunny_talwar

I have use dual function to create the dimension, I think all you need to do is to select numerical sorting on the sort tab for this dimension (GDB Count)

sunny_talwar

So you would need 8 charts, one for each PROCESS_STEP?

cbaqir
Specialist II
Specialist II
Author

the chart returns values based on two PROCESS_STEP selections and either the number of tickets from one step to the other or, in another chart, avg # days. I will be creating views for Submitted to Routing to Routed, Routed to Fully Approved (Moved to resourcing) and Routed to Ticket Closed.

cbaqir
Specialist II
Specialist II
Author

Duh thanks.

sunny_talwar

I am confused.... you want to PROCESS_STEPS then in this first view (let's take one view at a time)

cbaqir
Specialist II
Specialist II
Author

The calculations are based on the selection of 2 PROCESS_STEP.

Here is my first selections of Submitted to Routing and Routed. Is there a way to hardcode these selections in the charts so the user doesn't have to select them in the list box? These charts will be exported to a PPT file via Nprinting. The other views I will need are: Routed to Fully Approved (Moved to resourcing) and Routed to Ticket Closed

11-1-2017 11-01-43 AM.jpg