Action Script - Select in Field - Two dates

[#1]

Dear QV Experts,

In dashboard, we have total 8 charts in two sheets.

All the 6 charts are filtered based on MonthYear column.

Rest two charts are filtered based on WRNTY_PUR_DT column,

But the search string is same.

='>='& DATE(vFiscalStartDt)&'<='&DATE(vFiscalEndDt)

Now when i have MonthYear in ApplyDate Button, i could see only 6 charts are filtering & rest two charts show 'No data to display'.

I added WRNTY_PUR_DT in the Action Script, then only 2 charts are working.

Can you please suggest how to use two date in the 'Select in Field'

Thanks,

Sasi

[#2]

Dear Sasi,

All the 6 charts are filtered based on MonthYear column.

What is the meaning filtered Here.

MonthYear is a dimension or is a field when you click  MonthYear field then the six chart should display.

please give clarity on this.

Regards

Tripati

[sangeethag]

Hi,

Have you try like, add two select in Field. First add start date and second select in field add end date.

Otherwise ,if possible can you pls share sample qvw file.

[#4]

Dear All,

We have few solutions for Multiple Values in Search String. But dont see any examples for Multiple Field for same Search String.

MonthYear & WRNTY_PUR_DT should use the same search string,

='>='& DATE(vFiscalStartDt)&'<='&DATE(vFiscalEndDt)

Please suggest me.

Thanks,
Sasi

[sasikanth]

hi,

Have you tried by adding two triggers within same button ?

one for MonthYear  and Another for WRNTY_PUR_DT

[Anonymous]

Hi Sasi,

Are WRNTY_PUR_DT and MonthYear associated?

Kind regards

[#7]

I added two triggers, but the later one only works. If MonthYear is the prior one & WRNTY_PUR_DT is the second one. Then WRNTY_PUR_DT only works.

[#8]

Yeah Manuel. It is from the same table.

Premium_Calc:

LOAD CERT_SQN,

     MonthYear,

     BAND_SQN,

     MonthPremium ,

  STATUS_CODE,

  WRNTY_PUR_DT

FROM

[Anonymous]

Ok, can you share an example of your app?

I think there is a problem with your trigger.

Regards.

[sasikanth]

HI,

Might be problem in Triggers

please check the '=' symbol in the fieldname part , if there then please remove it

two triggers Should work