Set Analysis with Character dimensions

[shyamcharan]

Hi Experts,

Despite of looking at several example I still keep getting this question.

Set Analysis: Can we use the Set Analysis with Character dimensions?

If yes, can anyone please provide me information on any example that I can find.

This might be a very dumb question. I sincerely apologize for the guys who spend time on more important questions.

But your answers do help.

Thanks heaps in advance.

Regards,

Shyam.

[jyothish8807]

Hi Shayam,

Right now there is no null value for THE_DATE:

Try this in Dimension:

=if(isnull(THE_DATE)=-1,[EQUIPMENT_NUMBER],'')

Expression:

Count(Required field)

Regards

KC

[jonathandienst]

If you want it a a calculated dimension:

     =Aggr(If(IsNull(ExpiryDate), EquipmentNumber), EquipmentNumber)

[jagan]

Hi Shyam,

Can you explain with an example and your expected output.  If you don't have numeric value then use

=Only({<Product={'X'}>}DimensionName)

=MaxString(DimensionName)

=MinString(DimensionName)

Regards,

Jagan.

[tresesco]

Just in support of Jonathan, and to come up with an example: