Setting OnActivate Sheet Trigger on List Expression

nadkalyan — Fri, 26 Aug 2011 17:46:12 GMT

Hello ,

I have a list box with one expression that calculates number of Days based on 2 different dates as-

# of Days
if((((aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)) >= 0 and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate) <= 14),'0-14 Days', if((((aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)) >=15 and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate) <= 30),'15-30 Days', if((((aggr(max(LoadedDate), OpportunityNumber))-OpportunityCloseDate) >=31 and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)<= 60),'31-60 Days','61+ Days')))

# of Days

if((((aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)) >= 0

and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate) <= 14),'0-14 Days',

if((((aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)) >=15

and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate) <= 30),'15-30 Days',

if((((aggr(max(LoadedDate), OpportunityNumber))-OpportunityCloseDate) >=31

and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)<= 60),'31-60 Days','61+ Days')))

So this Expression gives me values as '0-14 Days', '15-30 Days','31-60 Days','61+ Days'

I would like to set the Trigger on the sheet based on "# of Days' Calculation so when sheet is activated, Select in Field option would be '0-14 Days' .

I was successful in setting the Triggers from Table Fields , but not sure how could i use List Box Expression field to acheive this.

Any insight into acheving this is very appreciated.

Thanks

Kalyan

topic Setting OnActivate Sheet Trigger on List Expression in QlikView

Setting OnActivate Sheet Trigger on List Expression