Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

debanjan_k
Not applicable

Number of Effictive day calculation

How to calculate Effective day in qlikview???

I use this code

=If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<@_Month=,@_FinFullYear=,@_TABLE={'SALE'}>}%_WEEKEND_DATE))<15,

MaxString({1<@_Month=,@_FinFullYear=,@_TABLE={'SALE'}>}%_WEEKEND_DATE))

but it does no work properly.first time its work properly but from 2nd time it does not work.

I want effective date repeatedly with respect to selection of start date by user. and here end date always be today.

2 Replies
MK_QSL
Not applicable

Re: Number of Effictive day calculation

Provide sample data or sample app to work!

sunny_talwar
Not applicable

Re: Number of Effictive day calculation

‌Like Manish has pointed out, it would be easier to troubleshoot your issue if you are able you to share a sample with us. Because it won't be easy to know what might not be working in your situation.