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

Make a chart with dates into days?

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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)

View solution in original post

4 Replies
swuehl
MVP
MVP

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)

nagireddy_qv
Creator II
Creator II

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

sfatoux72
Partner - Specialist
Partner - Specialist

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

Thank you for help!! I appreciate it!