Grouping by dimensions

[qlikofba]

Is there anyway to group by dimensions with similar names?

I have a dimension that prints out fields in a chart similar to this

1 year Special

1 year

2 year

3 year

2 year special

4 year

5 year

etc.

Is there anyway to have the values with special in them appear at the bottom?

[sunny_talwar]

Do you want to group them or push them to the bottom?

[qlikofba]

I would like to push them to the bottom, or top, and have all fields that say special all together.

[sunny_talwar]

You can try this as your calculated dimension:

Dual(FieldName, Left(FieldName, 1) * If(WildMatch(FieldName, '*special', 100))

[qlikofba]

I have a current calculated dimension of

=if(appl_typ_cd = 'CD' and renewal_dt >= '$(vAMaxFriday)' and renewal_dt <= '$(vEndMaxFriday)',  plan_desc_nm)

I then commented out my dimension and added in the one you posted.

When i copied and pasted your dimension(with fieldName= plan_desc_nm) it was displaying errors in expression, with the ( after Dual underlined in red.

[sunny_talwar]

Would you be able to share a sample to look at the issue?

[qlikofba]

I cannot post a sample of any data, I am sorry.

[sunny_talwar]

May be this link can help you, if confidentiality of data is a concern

Preparing examples for Upload - Reduction and Data Scrambling