topic Re: Bar Chart Help in QlikView

Bar Chart Help

Mon, 17 Feb 2014 03:45:59 GMT

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.

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;

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

Can you please help?

cheers

Re: Bar Chart Help

albertovarela — Mon, 17 Feb 2014 04:47:51 GMT

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

Hope this helps.

Re: Bar Chart Help

Mon, 17 Feb 2014 04:58:25 GMT

try this

AGGR(count(RECEIPT_REFERENCE),Month)

Re: Bar Chart Help

amit_saini — Mon, 17 Feb 2014 05:09:50 GMT

Hi Chris,

Please follow these steps:

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

Thanks,

AMIT SAINI

Re: Bar Chart Help

aveeeeeee7en — Mon, 17 Feb 2014 06:53:55 GMT

Hi Chris

Check the Attachments

Regards

Aviral

Re: Bar Chart Help

Mon, 17 Feb 2014 07:20:56 GMT

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.