Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Qlikview Bar chart

Guys,

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

Screenshot_1.png

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,

Screenshot_2.png

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,

Screenshot_3.png

Screenshot_4.png

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
atkinsow
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:

=Count({<Destination_Format_Flag={'-1'},DestMatch={'-1}>}UniqKey)