Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
try this ,
=if ('<<count({$<COMPLETED={1}>}TRAINING)<(count(TRAINING))and( ACTUALCONTRACTYEAR > min({$<COMPLETED={0}>}TRAINORDERING))>>',1,0)
ty.
i tried but all records disappear, and i know that the condition is true for three records
hi simone,
Can plz provide Sample .QVW , its helps to do fast
thxs ,
harish
Red records have condition true
the best solution would be a combo box to select on/off condition
tyvm
hi ,
Plz check the data , i just check in text box it showing "0". plz find the attactment !