Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
balrajahlawat
Champion
Champion

Most Urgent...Front End Calculation

Hello All,

Please find the attachment.

It is required for Daily Sales Outstanding.

and it should be like this:

Date        Initial O/S       Sales         Collection             Claims          Closing O/S           Days

Apr-14         50               20                10                        5                       55                     <120

May-14       55               15                  5                        10                      55                     <120

Jun-14         55              10                 10                         5                      50                      <120

Jul-14          50              15                 10                         5                      50                        105

Aug-14        50              10                   8                        10                      42                       104

Sep-14        42              10                 10                         10                     32                        84

Logic to calculate Days is:

If(Closing O/S-Sales<0, Closing O/S/Sales*30,

IF(Closing O/S-Sales-Previous(Sales)<0, ((Closing O/S-Sales)/Previous(Sales)*30)+30,

  IF(Closing O/S-Sales-Previous(Sales)-Previous(Previous(Sales))<0, ((Closing O/S-Sales-Previous(Sales)/Previous(Previous(Sales))*30)+60,

IF(Closing O/S-Sales-Previous(Sales)-Previous(Previous(Sales))-Previous(Previous(Previous(Sales)))<0, ((Closing O/S-Sales-Previous(Sales)-Previous(Previous(Sales)))/Previous(Previous(Previous(Sales)))*30)+90, "<120 days"


Here each time I need current and previous values of sales till my Closing Outstanding becomes<0.

I have done this at back end but now things are dynamic, I have to calculate them at front end only

I need a function which would work similar to previous() at front end.

Pls Suggest.

Regards,

Balraj

0 Replies