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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.