# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for
Did you mean:
Partner

## How to count the length of the intervall (in diagram)?

Hello,

i would like to count the length of the intervall and the number of intervals in the diagramm.

(not in the script)

i have a date and a value 0 or 1

ex

1.1.2016  0

2.1.2016  1

3.1.2016  1

4.1.2016  1

5.1.2016  0

6.1.2016  0

7.1.2016  1

8.1.2016  0

9.1.2016  1

10.1.2016  1

11.1.2016  0

12.1.2016  1

...

so i do have:

- 2 intervall of the length of 1

- 1 intervall of the length of 2

- 1 intervall of the length of 3

Any approch?

Many thx

Christoph

Do or Do Not. There is no try!
10 Replies
Specialist

Hi Cristoph,

Could you explain a little bit your question? Or attach an example.

Regards

Miguel del Valle

Perhaps this

Count(Interval(Len(Date#(Datefield,'DD.MM.YYYY')),'0','1') FieldName)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Author

Hi Miguel,

here we go:

number of intervals based on the value 1 and to count all intervals

but i need a solution in the diagram

manx thx

Do or Do Not. There is no try!

Like this

PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Author

Unfortunately this does not work - sorry

Do or Do Not. There is no try!
MVP & Luminary

I'm not sure if a pure gui solution will be possible but with some script-precalculation it might be solvable. Maybe this one within the attachment could be a starting point.

- Marcus

Partner
Author

Many thx - that is helpfull!

Do or Do Not. There is no try!
Creator II

Hi, You could use class as well.

Partner
Author

Many thx - very nice approch

Do or Do Not. There is no try!