filter by expression

[#1]

Hi all,

i m newbie user of QV.

i have a table like this :

ID	Name	Surname
1	Ted	Red
2	Sam	White

Ok now i have to show records only where the condition below is true(completed training etc.. are other fields)

<<count({$<COMPLETED={1}>}TRAINING)<(count(TRAINING))and( ACTUALCONTRACTYEAR > min({$<COMPLETED={0}>}TRAINORDERING))>>

I treid to insert it in conditional show box, but it doesn't work, any suggestion pls?

tyvm

Simone

[munna1317]

hi

try this ,

=if ('<<count({$<COMPLETED={1}>}TRAINING)<(count(TRAINING))and( ACTUALCONTRACTYEAR > min({$<COMPLETED={0}>}TRAINORDERING))>>',1,0)

[#3]

ty.

i tried but all records disappear, and i know that the condition is true for three records

[munna1317]

hi simone,

Can plz provide Sample .QVW , its helps to do fast

thxs ,

harish

[#5]

Red records have condition true

the best solution would be a combo box to select on/off condition

tyvm

[munna1317]

hi ,

Plz check the data , i just check in text box it showing "0". plz find the attactment !