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

Bar Chart Help


Good morning all.  I am stuck on creating a bar chart and wondered if you can pleae help.

Background:

5,000 receipts happened over two months.  The basic data of ARRIVAL_DATE (Date transaction occurred) and RECEIPT_REFERENCE (transaction reference) is needed to make a graph - BUT I have not had much experience with this.

Capture.JPG.jpg

Basically, I want to create a graph with a different bar for each month (as the X axis), showing a count of the receipt references  .

Similar to the below;

Capture2.JPG.jpg

I am confused as to what should be a dimension and what should be an expression.

Can you please help?

cheers

1 Solution

Accepted Solutions
Not applicable
Author

try this


AGGR(count(RECEIPT_REFERENCE),Month)

View solution in original post

5 Replies
albertovarela
Partner - Specialist
Partner - Specialist

Try the ARRIVAL_DATE as the dimension and under the expression type in =count(RECEIPT_REFERENCE)

Hope this helps.

Not applicable
Author

try this


AGGR(count(RECEIPT_REFERENCE),Month)

amit_saini
Master III
Master III

Hi Chris,

Please follow these steps:

  1. Right click--->New Sheet Object--> Charts
  2. Select  Bar chart
  3. Select  ARRIVAL_DATE as Dimension (Which belongs to X-axis)
  4. Write Count(RECEIPT_REFERENCE) in Expression

Thanks,

AMIT SAINI

aveeeeeee7en
Specialist III
Specialist III

Hi Chris

Check the Attachments

Regards

Aviral

Not applicable
Author

hi

Dual(Month(MyDate) & '-' & Date(MyDate, 'YY'), Num(Year(MyDate)) & Num(Month(MyDate), '00')) AS MonthYear, 

as dimension.

Note the Date(MyDate, 'YY') in the expression above.