topic Re: filter by expression in QlikView

filter by expression

Fri, 19 Sep 2014 12:11:59 GMT

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 — Fri, 19 Sep 2014 12:13:28 GMT

try this ,

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

Fri, 19 Sep 2014 12:20:28 GMT

ty.

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

munna1317 — Fri, 19 Sep 2014 12:23:36 GMT

hi simone,

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

thxs ,

harish

Fri, 19 Sep 2014 12:40:06 GMT

Red records have condition true

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

tyvm

munna1317 — Fri, 19 Sep 2014 13:16:18 GMT

hi ,

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