Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Experts,
=count({<Opened_date ={">=$(date(max(Opened_date)-7))<=$(date(max(Opened_date)))"},State={'Resolved'}>}Number)
The above expression showing total Resolved count but i need to show it as last 7 days count
please post your suggestions
Thanks
Gopinadh
try
=count({<Opened_date ={">=$(=date(max(Opened_date)-7))<=$(=date(max(Opened_date)))"},State={'Resolved'}>}Number)
@Dilip Thanks for your help but its not work properly
actually the original date was in timestamp format and after i was converted into date format date(floor(Opened),'DD/MM/YYYY') as opened_date
might be this has been the issue or not please correct me
data is like this
Number | Priority | State | Opened | Closed | Due date |
INC123 | 4 - Low | Open | 2018-10-10 10:43:29 | 2018-10-10 10:43:29 | |
INC124 | 4 - Low | Work in Progress | 2018-10-10 10:21:26 | 2018-10-13 10:21:26 | |
INC125 | 4 - Low | Work in Progress | 2018-10-10 10:18:59 | 2018-10-13 10:18:59 | |
INC126 | 4 - Low | Work in Progress | 2018-10-10 10:16:01 | 2018-10-13 10:16:01 | |
INC127 | 4 - Low | Open | 2018-10-10 10:14:56 | 2018-10-13 10:14:56 | |
INC128 | 4 - Low | Work in Progress | 2018-10-10 10:08:41 | 2018-10-15 10:08:41 |
Timestamp can cause issues. And should be removed or moved to a separate column
already converted into the date format date(floor(Opened),'DD/MM/YYYY') as opened_date
we can't change the master data
Any Suggestions Plz????
=count({<NEWDATE={"$(=Max(NEWDATE,7))"},State={'Resolved'}>}Number)
+count({<NEWDATE={"$(=Max(NEWDATE,6))"},State={'Resolved'}>}Number)
+count({<NEWDATE={"$(=Max(NEWDATE,5))"},State={'Resolved'}>}Number)
+count({<NEWDATE={"$(=Max(NEWDATE,4))"},State={'Resolved'}>}Number)
+count({<NEWDATE={"$(=Max(NEWDATE,3))"},State={'Resolved'}>}Number)
+count({<NEWDATE={"$(=Max(NEWDATE,2))"},State={'Resolved'}>}Number)
+count({<NEWDATE={"$(=Max(NEWDATE,1))"},State={'Resolved'}>}Number)
this exp is working fine is there any other way to make it short
Hi,
pay attention to your field name cases and date formats:
Your expression uses a field "Opened_date" (upper case "O") while your load script generates a field "opened_date" (lower case "o").
One possible solution might be:
=Count({$<opened_date ={">$(=Date(Max(opened_date)-7,'DD/MM/YYYY'))<=$(=Date(Max(opened_date),'DD/MM/YYYY'))"},State={'Resolved'}>}Number)
hope this helps
regards
Marco
Thanks for your reply marco
Still not working its showing zero
Could be format Issue? Or can you show using this below in text object and Show image?
='>=' & Date(max(Opened_date-7)) & '<=' & date(max(Opened_date))
seems to work for me:
hope this helps
regards
Marco