topic Re: interval table in QlikView

interval table

Wed, 25 Nov 2020 16:16:04 GMT

hi i have a table with a calculated dimension( periode en jours) i want to count values between 120 and 240 in this table any ideas

please?

sunny_talwar — Tue, 03 May 2016 16:49:29 GMT

May be this:

If(Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') > 120 and Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') < 240, 1, 0)

Tue, 03 May 2016 16:54:52 GMT

thanks for your reply i want to count haw many values between 120 and 240 in this calculated dimension ?

swuehl — Tue, 03 May 2016 17:05:46 GMT

You want to count in which context? In a text box?

Maybe like

Sum(

Aggr(

If(Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') > 120 and Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') < 240, 1, 0),

[NUM_COMM_...] // replace with your full field name you've used in your chart

)

sunny_talwar — Tue, 03 May 2016 17:26:21 GMT

I guess then follow how Stefan mentioned:

Count(Aggr(If(Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') > 120 and Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') < 240, 1, 0), YourChartDimensions))

Tue, 03 May 2016 17:33:36 GMT

thank you it works