Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have a look here: IntervalMatch
- Marcus
Marcus Thank you for your help , I could use the Interval Match functionality , however, necessary to present every day of the selected month , even if it has no record , I do not know if I could explain.
Ex.:
Are there missing records they must be generated, see: How to populate a sparsely populated field. But if I look on your table all dates are existing only a few events are missing - this would is easier the you could use something like: if(len(trim(Event))=0,'No Entry', Event) as Event.
- Marcus
Hi Roberto,
Check the attachment and let me know.
!
Note: I just created a sample data myself (Next time provide some sample data). Adapt the date format according to your need.
Hi Tamil !
Attached is an example of my problem . What I really need is for the presentation can be presented every day of the selected month . Introducing the days they had no record 0 (zero ) as a monthly report .
https://community.qlik.com/servlet/JiveServlet/downloadBody/13909-102-1-18151/Interval%20Match.qvw
Hi Roberto,
I am unable to download the file. Could you post the application directly here.!!
Hi, thanks, I think right now given the attachment.