Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

More qvd chart plotting woes...

Hello again,
Sorry for bombarding this forum recently. Thanks to all for your time and help.

My latest issue..
I am plotting a chart based on the data from qvdfs which are read in - each having a snapshot_date field, so I can plot a trend.
The chart shows a count of different severities in each file, with the snapshot_date value along the x-axis.

I want to show the count of each severity as a percentage or relative. However, when more than one qvd is loaded in, it takes it relative to the entire data-set, not the individual qvd files.

As you can see from the attached qvw, each fo the three graphs should have bars going up to 100% - which it does with only one qvd loaded in. This has 2 qvd's.

I appreciate any assistance you can offer with this.
Matt

1 Reply
johnw
Champion III
Champion III

count(RiskSeverity)/count(total <SnapshotDate> RiskSeverity)

Remove the "relative" checkmark, and format as a percentage.