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

Combo chart -show missing intervals

Hi all, bit of a newbie here, need your help please!

We have various companies (DNO's) that submit a set of files (A-H) for each month.

I'm trying to generate a combo bar chart which will visually display any missing files.

I have attached an example of what the chart would look like if all files were submitted but I want to see a white section (block) for any file types that are missing for that particular month for a specific company.

The DNO table has the actual files submitted by the companies and the SectionExpected table is just something I tried generating as a table that contains all combinations of Company and Section but not quite sure how to model it or what expressions I need to use to make the chart appear as desired.

Any help much appreciated!!!

0 Replies