Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vishuraina
New Contributor II

Handling multiple mode values : urgent

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.

1 Solution

Accepted Solutions
svinnakota
Contributor

Re: Handling multiple mode values : urgent

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

2 Replies
benoitgochel
New Contributor III

Re: Handling multiple mode values : urgent

Hi,

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

Hope this helps.

Best regards

svinnakota
Contributor

Re: Handling multiple mode values : urgent

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