Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following straight table with Tickets, Status, Create_Date, Year and Month:
I have a Selector with Year and Month and I need to list the Tickets from previous Months with Status = Open
For example, if I select Year = 2016 and Month = Jul, I'd see the following:
Now if I select Year = 2016 and Month = Aug, I'd see the following:
This would be selecting Year = 2016 and Month = Sep:
Do you know how could I do that?
Thank you!!!
PS. I attach a QVW with the file.
Check this out -
View solution in original post
try calculated Dimension
if (CREATE_DATE < max(CREATE_DATE), CREATE_DATE)
or if you have an Expression, use set Analysis
e.g. Count ({<CREATE_DATE={'<=$(=max(CREATE_DATE)'}>}TICKET
I tried it but it doesn't work. Could you take a look at the QVW? Thanks.
I can not upload your qvw
here is the epxression:
=count({<MONTH=,CREATE_DATE={'<$(=date(monthstart(max(CREATE_DATE))))'}>}TICKET)
BUT:
you need to Change your dateformat (it was M/D/YYYY, thats why it was not recognized as correct dateformat)
SET DateFormat='D/M/YYYY';
