Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
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
Thank you for help!! I appreciate it!