topic Make a chart with dates into days? in QlikView

Make a chart with dates into days?

Thu, 11 Feb 2016 22:35:08 GMT

Hi All,

I am trying to create a bar chart that would show me transaction values by day. I have a date field in my data, M-D-YYYY, called transaction date and I also have a field for transaction value. How would I create a chart that would show me how much transaction values occurred by each day? I am new to the Qlik world, so please bear with me. Any and all help is much appreciated.

Thanks,

-Moe

Re: Make a chart with dates into days?

swuehl — Thu, 11 Feb 2016 22:51:00 GMT

If your dates are intepreted correctly, you can use WeekDay(DateField) function to get the Weekday for any date.

Use this function in your load script or as calculated dimension in your chart

//script:

LOAD

DateField,

WeekDay(DateField) as Weekday,

....

=WeekDay(DateField) //calculated dimension

If you are looking for day of month, the function is called Day(DateField)

Re: Make a chart with dates into days?

nagireddy_qv — Thu, 11 Feb 2016 23:00:51 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Directory;

LOAD Date,

Day(Date) as Day

FROM

abc.xlsx

Re: Make a chart with dates into days?

sfatoux72 — Thu, 11 Feb 2016 23:08:59 GMT

Create a bar chart
use TransactionDate as dimension
use the following expression : Count(TransactionValue)

Re: Make a chart with dates into days?

Thu, 11 Feb 2016 23:13:50 GMT

Thank you for help!! I appreciate it!