Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to present the data as an example, interval match, i need help?

qlikview.png

7 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Have a look here: IntervalMatch

- Marcus

Not applicable
Author

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.:

qlikview1.png

marcus_sommer
MVP & Luminary
MVP & Luminary

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

tamilarasu

Hi Roberto,

Check the attachment and let me know.

Capture.PNG !

Note: I just created a sample data myself (Next time provide some sample data). Adapt the date format according to your need.

Not applicable
Author

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






tamilarasu

Hi Roberto,

I am unable to download the file. Could you post the application directly here.!!

Not applicable
Author

Hi, thanks, I think right now given the attachment.