topic max and interval in script in QlikView

max and interval in script

Mon, 23 Nov 2009 05:40:17 GMT

Hi,

I have data like the following:

Table1:

Id	Seg
1	260
1	144
1	555
2	628
2	953
2	876
2	212
3	142
3	523
4	189
4	634
4	988
4	755

I need to achieve the following result (in the script):

Table2:

Id	Final Seg
1	144
2	953
3	142
4	988

Where "Final Seg" =
for each Id
if one of the values (Seg) is in the interval [140 - 146] then
finalSeg = Seg
else // no Seg value in the interval
finalSeg = the max Seg value (for this Id)
end
end

Thanks.

max and interval in script

Mon, 23 Nov 2009 11:52:38 GMT

Hi,

Please find the attached application as per your requirment.

Regards,

Sridhar Chitikela

max and interval in script

Mon, 23 Nov 2009 18:59:07 GMT

Hi,

The solution was published at: http://community.qlik.com/forums/t/22794.aspx

Best regards.