topic Re: Action Script - Select in Field - Two dates in QlikView

Action Script - Select in Field - Two dates

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Action Script - Select in Field - Two dates

Wed, 08 Jun 2016 10:52:13 GMT

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

Re: Action Script - Select in Field - Two dates

sangeethag — Wed, 08 Jun 2016 11:11:41 GMT

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.

Re: Action Script - Select in Field - Two dates

Wed, 08 Jun 2016 11:30:10 GMT

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

Re: Action Script - Select in Field - Two dates

sasikanth — Wed, 08 Jun 2016 11:33:57 GMT

hi,

Have you tried by adding two triggers within same button ?

one for MonthYear and Another for WRNTY_PUR_DT

Re: Action Script - Select in Field - Two dates

Anonymous — Wed, 08 Jun 2016 11:40:15 GMT

Hi Sasi,

Are WRNTY_PUR_DT and MonthYear associated?

Kind regards

Re: Action Script - Select in Field - Two dates

Wed, 08 Jun 2016 11:41:47 GMT

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.

Re: Action Script - Select in Field - Two dates

Wed, 08 Jun 2016 11:42:26 GMT

Yeah Manuel. It is from the same table.

Premium_Calc:

LOAD CERT_SQN,

MonthYear,

BAND_SQN,

MonthPremium ,

STATUS_CODE,

WRNTY_PUR_DT

FROM

Re: Action Script - Select in Field - Two dates

Anonymous — Wed, 08 Jun 2016 11:45:04 GMT

Ok, can you share an example of your app?

I think there is a problem with your trigger.

Regards.

Re: Action Script - Select in Field - Two dates

sasikanth — Wed, 08 Jun 2016 11:50:29 GMT

HI,

Might be problem in Triggers

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

two triggers Should work

Re: Action Script - Select in Field - Two dates

marcus_sommer — Wed, 08 Jun 2016 11:51:59 GMT

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

Re: Action Script - Select in Field - Two dates

Wed, 08 Jun 2016 13:26:57 GMT

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.