Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
debanjan_k
Partner - Contributor II
Partner - Contributor II

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
MVP
MVP

Provide sample data or sample app to work!

sunny_talwar

‌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.