Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Qlikview Bar chart


I'm having a grouped bar chart having field count based on the source and destination format as below,


In this chart the customer 'Cargosmart' has one mapping and it's showing the exact count for source and destination that I need.

But some customers also having two mappings as shown below,


In this chart it shows the count for two mappings but the field count is wrong. When I select message format individually, it is showing the correct value as shown below,



It adds those two values (119 + 61) = 180

Plz help me guys on how to split the count for those two mappings in the bar chart. I have forwarded the sample data and QVW file below.

1 Reply
Specialist II
Specialist II

I think you need to add logic where MessageFormat=[Destination Format] for your chart.

I would probably add another flag in the script something like:

if(MessageFormat=[Destination Format],-1,0) as DestMatch

Then in your chart your expression for Destination Format would be: