Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vishuraina
Contributor III
Contributor III

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
Creator
Creator

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

View solution in original post

2 Replies
benoitgochel
Contributor III
Contributor III

Hi,

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

Hope this helps.

Best regards

svinnakota
Creator
Creator

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