Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

qlikview.png

7 Replies
marcus_sommer
Not applicable

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

Have a look here: IntervalMatch

- Marcus

Not applicable

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

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
Not applicable

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

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
Not applicable

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

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

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

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
Not applicable

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

Hi Roberto,

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

Not applicable

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

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