I need to add more calculation and have the measure to show rolling values meaning Aug 16 should show 8.07 + the above 4.85= 12.92 and Oct 16 = 2.35 + the above 12.92 = 15.27 and so on.. then I need to do limit data to show top 5 only..
This expression gives me the numbers correctly but I need to show only the top 5 values(cumulative). when trying to do limit to top 5 five in the dimension in QllikSense I get weird values.. Is there anyway I can look for the highest 5 results and only display them?
Are you using Qlik Sense 3.0? If not, then I think there was a bug which causes this issue. I know Stefan came up with a way to hide them, but I never paid attention to his response in another thread. I can't even say if his alternative will work here or not, but if possible, upgrade to Qlik Sense 3.0 and you should be good