topic Grouping by dimensions in QlikView

Grouping by dimensions

qlikofba — Wed, 13 Apr 2016 18:03:55 GMT

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?

Re: Grouping by dimensions

sunny_talwar — Wed, 13 Apr 2016 18:33:50 GMT

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

Re: Grouping by dimensions

qlikofba — Wed, 13 Apr 2016 18:35:28 GMT

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

Re: Grouping by dimensions

sunny_talwar — Wed, 13 Apr 2016 18:55:22 GMT

You can try this as your calculated dimension:

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

Re: Grouping by dimensions

qlikofba — Mon, 18 Apr 2016 17:33:52 GMT

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.

Re: Grouping by dimensions

sunny_talwar — Mon, 18 Apr 2016 18:00:20 GMT

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

Re: Grouping by dimensions

qlikofba — Mon, 18 Apr 2016 18:02:38 GMT

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

Re: Grouping by dimensions

sunny_talwar — Mon, 18 Apr 2016 18:15:55 GMT

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

Preparing examples for Upload - Reduction and Data Scrambling