Handling multiple mode values : urgent

[Anonymous]

Hi all,

Qliksense gives null values when more than 1 values occur as the mode. I need to show at least 1 value in cases like these where multiple modes are coming.Is there a work around for the same? This is an urgent request, any help is appreciated.

[benoitgochel]

Hi,

Maybe try with Max(Count()) after testing your mode function with isNull() ...

Hope this helps.

Best regards

[svinnakota · Accepted solution]

Hi,

If the mode is numeric field, use min/max during the loading script.

If you are displaying the data in the UI then post the sample app with the sample data, so that we can have a look and suggest you some thing.

Try to use first sorted value function to get to get the first record when multiple modes are present.

Santosh