Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

To increase the bill amount by %

To increase the bill amount by % if last pay date < current date

 for next 7 days                 12.5%

 for next 10 days               15%

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

I would probably do this in the script, but it is possible to use it front end inside an expression as well

 

If(today()-LastPayDate >=10, //identify 10d or more

   BillAmount * 1.15,

   If(today()-LastPayDate >=7, //identify 7-10 days

      BillAmount * 1.125,

      BillAmount * 1.00 ) AS NewBillAmount

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

I would probably do this in the script, but it is possible to use it front end inside an expression as well

 

If(today()-LastPayDate >=10, //identify 10d or more

   BillAmount * 1.15,

   If(today()-LastPayDate >=7, //identify 7-10 days

      BillAmount * 1.125,

      BillAmount * 1.00 ) AS NewBillAmount

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post