topic Re: GetFieldSelection error in QlikView

GetFieldSelection error

sutoniusahadong — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

Can any body help for this error ..

=Count({$<[Valid To]={'$('>&GetFieldSelections(periode)&'-01-01)'}, [Valid From]={'${<'&GetFieldSelections(periode)&'-02-01')}>}DISTINCT [Emp No])

Toni

jonathandienst — Wed, 30 Jan 2019 05:19:08 GMT

What are you trying to do and what is the error? GetFieldSelections is probably not the best way to do it.

sutoniusahadong — Wed, 30 Jan 2019 06:26:19 GMT

Tq for your repply,

I want create table fulfillment, and the value will appear trigger from periode (current year, year -1, year -2, and year-3)

i do this to solved :

1. Create variable JAN until DEC : =date(GetFieldSelections(periode)&'-02-01','YYYY-MM-DD')

2. expresion for JANUARI is =Count(DISTINCT {<[Valid To]= {">=$(JAN)"}, [Valid From]={"<=$(FEB)"}>} [Emp No])

Toni