topic How to create a range or interval as a condition for summing amount in QlikView

How to create a range or interval as a condition for summing amount

Sat, 31 Oct 2015 15:47:39 GMT

Please I have a question ? I have two fields, one is called Loss and the second one is

time of detection.

First field contains amounts of loss and second contains days of how long it take to detect.

I need to create intervals from the time of detection field and based on the selected interval to sum the corresponding loss from the Loss field ?

Re: How to create a range or interval as a condition for summing amount

maxgro — Sat, 31 Oct 2015 18:12:42 GMT

you can use a calculated dimension with the class function (the 2nd parameter is the class interval, in my example 5); for different interval you can use nested if instead of class

load * inline [

loss, time

100,3

110,4

120,5

90,1

45,20

70,15

56,12

];