Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Action Script - Select in Field - Two dates

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

11 Replies
Highlighted
Not applicable

Re: Action Script - Select in Field - Two dates

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

Highlighted
Contributor III
Contributor III

Re: Action Script - Select in Field - Two dates

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.

Highlighted
Not applicable

Re: Action Script - Select in Field - Two dates

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

Highlighted
Specialist III
Specialist III

Re: Action Script - Select in Field - Two dates

hi,

Have you tried by adding two triggers within same button ?

one for MonthYear  and Another for WRNTY_PUR_DT

Highlighted
Specialist III
Specialist III

Re: Action Script - Select in Field - Two dates

Hi Sasi,

Are WRNTY_PUR_DT and MonthYear associated?

Kind regards


Highlighted
Not applicable

Re: Action Script - Select in Field - Two dates

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.

Highlighted
Not applicable

Re: Action Script - Select in Field - Two dates

Yeah Manuel. It is from the same table.

Premium_Calc:

LOAD CERT_SQN,

     MonthYear,

     BAND_SQN,

     MonthPremium ,

  STATUS_CODE,

  WRNTY_PUR_DT

FROM

Highlighted
Specialist III
Specialist III

Re: Action Script - Select in Field - Two dates

Ok, can you share an example of your app?

I think there is a problem with your trigger.

Regards.

Highlighted
Specialist III
Specialist III

Re: Action Script - Select in Field - Two dates

HI,

Might be problem in Triggers

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

two triggers Should work