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

1 Solution

Accepted Solutions
sunny_talwar

I updated your dimension to this

=Aggr(

If(Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}GOV_DECISION_BODY_SUB) = 0, Dual(0, 0),

If(Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}GOV_DECISION_BODY_SUB) = 1, Dual(1, 1),

If(Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}GOV_DECISION_BODY_SUB) < 4, Dual('2-3', 2),

If(Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}GOV_DECISION_BODY_SUB) < 6, Dual('4-5', 4), Dual('6 or more', 6))))),

DEFECT_ID)

And expression to this

Count({$<

MONTH_1 = {"$(='>=' & Date(MonthStart(Max({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}MONTH_1), -11), 'MM-YY') & '<' & Date(MonthStart(Max({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}MONTH_1), 1), 'MM-YY'))"},

// DEFECT_ID = {"=Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}, IS_IN_PROD = {'Y'}>}PROCESS_STEP) = GetSelectedCount(PROCESS_STEP)"},

PROCESS_STEP = {'Submitted to Routing', 'Routed'},

IS_IN_PROD = {'Y'}>} DISTINCT DEFECT_ID)

Did you look at this qvw? Attaching again

View solution in original post

35 Replies
vkish16161
Creator III
Creator III

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

cbaqir
Specialist II
Specialist II
Author

Never used that before. Syntax example?

sunny_talwar

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)

vkish16161
Creator III
Creator III

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.

cbaqir
Specialist II
Specialist II
Author

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

sunny_talwar

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

cbaqir
Specialist II
Specialist II
Author

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.

sunny_talwar

Check attached

Capture.PNG

sunny_talwar

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