topic Re: From Date and To Date issue in calendar object in QlikView

From Date and To Date issue in calendar object

jelly_gvm — Tue, 25 Aug 2015 06:40:31 GMT

Hi,

I am having From Date and To Date filters in my dashboard, if I select the date in From Date filter the data is not filtering on Tablebox data and also i have applied the field event triggers and variable event triggers. But still the dates are not filtering on Tablebox data. See the screen shots. Same for the To Date.

Kindly suggest me, if any other changes are required for the above issue to resolve.

Thanks in advance

Regards,

Ram M

Message was edited by: Ram M

Re: From Date and To Date issue in calendar object

kaushiknsolanki — Tue, 25 Aug 2015 06:43:21 GMT

Dear Ram,

Do not go for field Triggers,cause they may cause bad performance.

What you can do is get the ToDate and FromDate in variable and use those variables in your chart expression using set analysis.

Regards,

Kaushik Solanki

Re: From Date and To Date issue in calendar object

Digvijay_Singh — Tue, 25 Aug 2015 06:48:34 GMT

I think if table is not getting filtered means something is wrong with the associations. Check if there is any name difference etc. Also try selecting in table, associations should work from all directions.

Re: From Date and To Date issue in calendar object

krishna20 — Tue, 25 Aug 2015 06:49:38 GMT

Hi Ram,

Tackling dates is very critical issue. Can't estimate what will be the problem in dates. So, Please share sample file.It will be helpful to us guide you in right way.

Re: From Date and To Date issue in calendar object

jonathandienst — Tue, 25 Aug 2015 06:53:20 GMT

Are From Date and To Date field or variable selections? How do they relate to the MonthYear field you showed?

I would not use a table box for this, but rather a straight table because a table box does not allow for expressions which can contain filters.

I suggest that you post your qvw or a representative sample or that you can get more accurate help.

Re: From Date and To Date issue in calendar object

jelly_gvm — Tue, 25 Aug 2015 07:26:51 GMT

Hi Kaushik,

There is no charts in the dashboard only table box, because for better performance i just use a tablebox to present the data and there is no calculations fields and no expressions are required.

I have use the variables vFromDate & vToDate and set the Min value ( =Min({1} Rundate ) and max values ( =Max({1} Rundate ) for the both the variables in Calendar.

Please share me if any app. for this issue.

Thanks,

Ram

Re: From Date and To Date issue in calendar object

jelly_gvm — Tue, 25 Aug 2015 08:29:21 GMT

I will post the sample app for this issue.

Thanks,

Ram

Re: From Date and To Date issue in calendar object

kaushiknsolanki — Tue, 25 Aug 2015 08:41:16 GMT

Dear RAM,

You can use the chart option (Straight Table) which will also act as tablebox. The advantage with that is you can have a simple expression like Sum(1) with the set analysis and you can hide that expression.

So for end user it will look same like tablebox with required result.

Regards,

Kaushik Solanki

Re: From Date and To Date issue in calendar object

jelly_gvm — Tue, 25 Aug 2015 08:51:24 GMT

Hi Kaushik,

Thanks for your reply.

there is a some performance issue, so that is what we are using the Tablebox to increasing the dashboard performance, Previously i was using the same logic which you have suggested, after a lot of analysis we can to know to use the tablebox instead Straight table.

Note:- 12 milllion record for each table

Regards,

Ram

Re: From Date and To Date issue in calendar object

jelly_gvm — Tue, 25 Aug 2015 10:17:53 GMT

Hi Krishna,

I have attached the sample file kindly suggest me to resolve the issue.

Thanks,

Ram

Re: From Date and To Date issue in calendar object

jelly_gvm — Tue, 25 Aug 2015 10:23:41 GMT

Hi Jonathan,

PFA sample file, please update the file if any changes are required to for this issue.

Thanks,

Ram

Re: From Date and To Date issue in calendar object

krishna20 — Tue, 25 Aug 2015 11:47:24 GMT

Hi Ram,

I see only two dates in your app i.e 7/22/2015 and 8/24/2015. I don't know what you are trying to do??

Please check LAST_UPDATED_Date.

You have shown LAST_UPDATED_DATE in table box. The table box data needs to filter depends on selections in arbitrary dates right?? Is this your requirement ?? If yes please check LAST_UPDATED_DATE.

Re: From Date and To Date issue in calendar object

jelly_gvm — Tue, 25 Aug 2015 12:10:17 GMT

Yes Krishna,

I've tried with all the possibilities, but i didn't get any solution for this issue. Please update file if any changes are required for this issue.

Thanks,

Ram