This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Any suggestions on writing the expression for the below case that I would like to see on a Monthly bar chart (Month is the dimension)
ScheduledDate<=MonthEnd of every month
Jan: count of all tickets where scheduledDate <=Jan (including jan 2016,dec 2015, nov 2015 & so on)
Feb: count of all tickets where scheduledDate <=Feb (including feb 2016, jan 2016,dec 2015, nov 2015 & so on)
Mar: count of all tickets where scheduledDate <=Mar etc
Thank you in advance.
Take a look if this is what you are looking for.
View solution in original post
Are you looking for something like this
Thank you for the response.
The date field for the month(dimension) and the scheduled date are the same in my case. ie. the month(dimension) is nothing but month(ScheduledDate). So, given your expression I should actually be using
This ain't working. Do you have any suggestions for this case?
Could you post a sample qvw and explain your expected output?
Try like this...
Here is a picture of what I am working towards having-
Thank you for the response & Let me know in case you need more information.
This works perfect. Thanks a ton.