Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Calculated Expression not displaying in Bar Graph

I want to create a bar graph that counts the total of sales types for each reporting period.  However I want to combine all the 'Include' records in one graph (stacked... but not separated by each 'sales type')

Report Period       SalesType

1                            Include

1                            Exlcude

1                            Include - Sale

1                            Include - Tax

1                            Include - credit

1                            Include - Coupon

1                            Exclude - Reject

1                            Exlcude - Feature

1                            Include - Salary

1                            Include - Salary

1                            Include - Salary

1                            Include - Salary

1                            Include - Salary

Desired End Result:

Include: 10

Exclude: 1

Exclude - Reject: 1

Exclude - Feature: 1

I tried creating separate expressions for each count but when I do this only 1 graph is displayed.  Please Help!

Exp1: =Count ({<SalesType={'Include','Include - Sale','Include - Tax','Include - credit','Include - Coupon'}>} SalesType)

Exp2:  =Count ({<SalesType={'Exclude'}>} SalesType)

1 Solution

Accepted Solutions
Master
Master

9 Replies
Contributor III
Contributor III

Example of bar Graph not displaying correctlyGraph Example.PNG

Master
Master

Capture.JPGYou need calculated dimension

=if(WildMatch(SalesType,'Include*'),'Include',SalesType)

Would you be able to share your qvw file?

Master
Master

and expression will be count([Report Period])

Contributor III
Contributor III

could you please add the qvw?

Specialist II
Specialist II

Like this,

Capture.JPG

Master
Master

Contributor III
Contributor III

Thank you!!!!

Master
Master

Glad to know it worked