a dual field

[Anonymous]

Hi,

The field Month is dual in my application - it is both numeric and string.

My task is to get a string value of the minimal Month selected by the user.

The formula min(Month) results in a numeriс value. How can I set it to give a string result?

Thank you in advacne,

Larisa

[Qrishna]

monthname (min(Month)) or month(min(Month))

[petter]

Month( MakeDate(2015, Min(Month) ,1 ) )

[swuehl]

If you have an arbitrary text value and you don't want to re-apply a QV Date function:

=FirstSortedValue( Month, Month)

[Anonymous]

Actually I have an arbitarary text. Month name is in Russian to it's a plane text.

But the function FirstSortedValue( Month, Month) doesn't work in my case. The result is '-'.

I'm quite sure that the field is dual.

[antoniotiman · Accepted solution]

Try

FirstSortedValue(DISTINCT Month,Month)

[Anonymous]

It works! Thank you!

How can I get the maximal value?

LastSortedValue doesn't work.

[antoniotiman]

FirstSortedValue(DISTINCT Month,-Month)

[swuehl]

I believe it should return the correct value, assuming Month being a dual value. Please double check.

Create a straight table chart with dimension Month, and an expression

=num(Month)

Please post the screenshot of that chart.

[Anonymous]

Hi swuel,

I've experimented.

It works this way:

FirstSortedValue(distinct Месяц, Месяц) & ' – ' &FirstSortedValue(distinct Месяц, Месяц, Count(distinct Месяц))

FirstSortedValue(distinct Месяц, Месяц) - gets the minimal month

FirstSortedValue(distinct Месяц, Месяц, Count(distinct Месяц)) - gets the maximal month

You and Antonio helped. Thank you!