Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
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.
Maybe try with Max(Count()) after testing your mode function with isNull() ...
Hope this helps.