Hello,
I have created table and I need recieve data:
1) (DIMENSION) In first tabel I need to recieve only activities done today. This is what I have now (=ITL_DATA_DATE)
![michak80_0-1633350306871.png michak80_0-1633350306871.png](https://community.qlik.com/t5/image/serverpage/image-id/63262i185EED84F1C18E61/image-size/medium?v=v2&px=400)
I try this =if (match (ITL_DATA_DAY, '2021-01-04'),ITL_DATA_DAY) but of course tommorow it will not be work. I also tried 'today()' insted of 2021-01-04 but it doesn't work
2) (MESSAURE) I need to recieve quantity of orders cretaed between yesterday 13:00 and today 13:00. This is what I have no Count({<OH_ORDER_TYPE = {P}>}distinct ITL_ORDER_ID) but I see all orders create today (from 00:00).
Today I need to see all orders created between 2021-10-03 01:00 PM and 2021-10-04 01:00 PM
Tomorow the same but created between 2021-10-04 01:00 PM and 2021-10-05 01:00 PM
...
Could you please help me? Thank you in advance.