Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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