topic Re: Rename Class and Specify Buckets in QlikView

Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:04:47 GMT

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:

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.
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.
If possible, rename the 0-1 bucket to Low Complexity, rename 2-3 to Medium etc

Any suggestions?

Thanks in advance!

stalwar1

Re: Rename Class and Specify Buckets

vkish16161 — Wed, 01 Nov 2017 17:11:23 GMT

You can try using Valuelist for the replacement of the dimension values.

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:16:32 GMT

Never used that before. Syntax example?

Re: Rename Class and Specify Buckets

sunny_talwar — Wed, 01 Nov 2017 17:19:45 GMT

I understand the 1st requirement, but 2 and 3 looks similar, but I am not sure what is really needed... do you need names for those groupings (Point 3) or do you need some very specific grouping (Point 2)

Re: Rename Class and Specify Buckets

vkish16161 — Wed, 01 Nov 2017 17:19:56 GMT

ValueList() – For those tricky situations

The above post will explain that.

It's used to create synthetic dimensions. Basically, dimensions that don't exist in the data model.

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:27:39 GMT

2 is stratify the buckets not by every 2, but by 0,1,2-3,4-5,6+

3 is to rename those buckets 0 = Very Low, 1 = Low, 2-3 = Medium etc

Re: Rename Class and Specify Buckets

sunny_talwar — Wed, 01 Nov 2017 17:37:53 GMT

Do you need two different views? 1 for 2 and 1 for 3 or 2 is a step in process to get to 3?

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:41:27 GMT

one view. 2 is a step to get to 3 and 3 is not required - but would be a nice to have if possible. 1 and 2 are more important.

Re: Rename Class and Specify Buckets

sunny_talwar — Wed, 01 Nov 2017 17:42:50 GMT

Check attached

Re: Rename Class and Specify Buckets

sunny_talwar — Wed, 01 Nov 2017 17:46:15 GMT

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

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:46:47 GMT

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

Re: Rename Class and Specify Buckets

sunny_talwar — Wed, 01 Nov 2017 17:48:05 GMT

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

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:48:06 GMT

And what about hard coding the selections? Any ideas?

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:49:54 GMT

both..if possible, in numerical order?

Re: Rename Class and Specify Buckets

sunny_talwar — Wed, 01 Nov 2017 17:53:07 GMT

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)

Re: Rename Class and Specify Buckets

sunny_talwar — Wed, 01 Nov 2017 17:53:21 GMT

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

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:55:21 GMT

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.

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 17:56:01 GMT

Duh thanks.

Re: Rename Class and Specify Buckets

sunny_talwar — Wed, 01 Nov 2017 17:58:02 GMT

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

Re: Rename Class and Specify Buckets

cbaqir — Wed, 01 Nov 2017 18:03:20 GMT

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