Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

filter by expression

Hi all,

i m newbie user of QV.

i have a table like this :

IDNameSurname
1TedRed
2SamWhite

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

5 Replies
munna1317
Contributor II

Re: filter by expression

hi

try this ,

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

Not applicable

Re: filter by expression

ty.

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

munna1317
Contributor II

Re: filter by expression

hi simone,

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

thxs ,

harish

Not applicable

Re: Re: filter by expression

Red records have condition true

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

tyvm

munna1317
Contributor II

Re: Re: Re: filter by expression

hi ,

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

Community Browser