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 count no.of Intervals?

Hi ,

    I have table with name,id,date, startinterval and endinterval(halfhour wise) fields.My requirement is:

i need to calculate

if(each Endinterval count id's/ecah Startinterval count if id's)>=70% then take how many intervals getting more than 70% then take count of intervals. like wise for all intervals.

I need to show this value in chart datewise how many intervals getting more than 70%.

EX:

Startinterval      Endinterval

10:30               10:30

10:30               10:30

10:30                11:00
11:00                11:00

11:30               12:00

12:00                12:30

Thanks

Ashok.

1 Reply
Not applicable

Re: How to count no.of Intervals?

if I understand

Community Browser