Incorrect stacked chart calculation in Sense

[Anonymous]

I'm trying to show the breakdown of a count of vulnerabilities by severity. Severities are either 3,4 or 5. The chart is done by time on the X axis against count of vulnerabilities on the Y.

My issue is that although the total number of vulnerabilities is correct (1,346) the split in the chart is not. See the graphic below. The chart shows them roughly equally split but the totals to the side are the real values and show a different split. Blues are Severity 3, Yellow 4 and Red 5.

The measure I'm using has the following calculation:

RANGESUM(ABOVE(TOTAL Count(Severity),0, ROWNO(TOTAL)))

Can anyone suggest how to correct the split in this calculation please ?

Thanks

[sunny_talwar]

Can you share a screenshot of the error message you got?

[Anonymous]

Sure

[sunny_talwar]

It appears that you have script after what you have shared and that is where the error is taking place... I won't know until I see the unshared script

[Anonymous]

Originally there was some script but it was all commented with // on each line.

I also previously thought that because there was a reference to End in that area that it might be the issue, so I removed all the commented script. Saved it and reloaded. Same problem.

The only info in the Data Editor is as shown above plus a setup piece at the top of the file as shown here:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=4;

SET FirstMonthOfYear=1;

SET CollationLocale='en-GB';

SET CreateSearchIndexOnReload=1;

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Is there a cache somewhere  that the old editor script is in - that I can flush ?

[sunny_talwar]

I have not used Qlik Sense too much to know about this, but I have not seen this kind of issue before. Not really sure what you can do... may be create a new version of the app to test it out?