Mode() Function for 1 record

[cloud]

Hi experts,

I want to get the mode for the name for the current month, but for the current month, it has only 1 existing record. This is my expression that displays the name in a textbox in Qlikview:

Mode({<Month ={"$(=vCurrentMonth)"}>} Name)

The result that it shows for that current month is blank ( is it because it's returning NULL?)

Would like it to display the name regardless of whether it has 1 or more records.

Appreciate any help, please type in example instead of putting Qlikview files, thank you.

[lironbaram]

hi 

there is nothing special in the expression 

this is the expression :

=mode({<Reporting={"$(vCurrentMonth)"}>}name)

and this the variable expression 

=date(max(Reporting),'MM/DD/YYYY')

the only other change is that the field Reporting 

contains values like this 01/05/2019 for May and 01/04/2019 for April