Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

sakamsureshbabu
Contributor

Expression

Hi

i have below Exp

in that {[BILL DATE] >= 'Start',[BILL DATE]<='End' is used for starting and end date selection.

but it showing error How can write this..

(sum({<DETAILENTRYTYPE = {'B'}, CANCELLED = {'N'}, ESTIMATE = {'N'} ,{[BILL DATE] >= 'Start',[BILL DATE]<='End'}>}DETAILSTONEWEIGHT))

2 Replies
sushil353
Honored Contributor II

Re: Expression

Hi,

Try Below

Sum({<DETAILENTRYTYPE = {'B'},CANCELLED = {'N'},BILLDATE ={" >=$(Start) <= $(End) "} >} DETAILSTONEWEIGHT)

HTH

Sushil

Re: Expression

Hi,

I assume Start and End is the variables then write like

= Sum({<DETAILENTRYTYPE = {'B'}, CANCELLED = {'N'}, ESTIMATE = {'N'} ,

   [BILL DATE]  ={ ' >=$(Start)  <= $(End) ' }>}DETAILSTONEWEIGHT)

Regards

Anand

Community Browser