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

[marcus_sommer]

You couldn't solve it within the selection-action. The message 'No Data ...' meant that there is no valid association between your selections and the data within the other two charts and this is the qlik default-behaviour regarding to selection states green/white/grey: Colors, States and State vectors.

This meant you need to use set analysis: Set Analysis: syntaxes, examples to be able to ignore selections or the use of alternate states: Qlikview-Alternate States Fundamental-Inheritted vs Default.

- Marcus

[#3]

Thanks All.

Fixed the issue.

I opened the MonthYear column & using set analysis in the expression.

=Count({<MonthYear = , WRNTY_PUR_DT = {'>=$(#vFiscalStartDt)<=$(#vFiscalEndDt)'}  >} distinct CERT_SQN)

It is working fine. Thanks all for your support.