Who can help me on my select problem?

Wed, 21 Dec 2011 09:21:18 GMT

I think this might be a chalange for some people

Who can help? I try to explain what is happening.

I have a list box with amount of days, called rangedays.

I also have a table with many fields and one is a calculated agveval field, which is how old the record is.

When I click on a rangeday, i do a select on the table with ageval <= rangedays. (This is in a trigger, onChange and onSelect on rangedays)

'Field' = ageval, 'Search String' = ='<='&rangedays

The values of ageval in the table/records are from 7 to 999.

I also have a field, showing GetSelectedCount(ageval)

This all seem to work, so now the problem so far.

I now first do a sub-select of other values and lock them. (The lowest ageval value of these records is 40)

When I now click on rangedays 47, I see that GetSelectedCount(ageval) is 3 (which is fine and correct)

But when I click on any rangeday number between 7 and 39, it will not change the GetSelectedCount(ageval) value. As there are non, I would like to see that.

When I click on 6 or lower, the GetSelectedCount(ageval) now is changing to 0, which is the number in the whole table.

So what i think the GetSelectedCount is not working as I had hoped.

I like to know how many records are left from my subselect.

Is there maybe an other function for that? Or another solution to my challenge?

Who can help me on my select problem?

Wed, 21 Dec 2011 11:05:28 GMT

I think I resolved my own problem, with help on another question I had.

I first needed to do a clear on the specific field.

To do that, I do a "select in Field" with a blank search string.

topic Who can help me on my select problem? in QlikView

Who can help me on my select problem?

Who can help me on my select problem?