Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jebamalai
Specialist
Specialist

Sales Variation Based on Billing Days

Hi Team,

Can any one share some examples of the sales calculation made based on the Billing Days.

To give you more idea about the requirement.

Apr 2014 sales was 12000 and we had 20 Billing days.In Apr 2015 the sales for the month so far is 9000, and we have 21 Billing days and 2 more Biling days to go.

When I want to compare the Current sales with previous sales the calculation should work by below logic

(12000/19)*21

The Billing days are connected to calendar dates and the above calculation should be dynamic based on the date range.

Could you please check and guide me to the right path

Thanks & Regards

Jeba

6 Replies
albi_prakash
Creator II
Creator II

Hi,

  Did you tried with networkdays()? It  will work for (Mon-Fri)

-Jay

jebamalai
Specialist
Specialist
Author

Hi,

Its not only to do with Networkdays.

I have few countries which follows different holiday pattern.

Hence I want to connect the number of Billing Days based on Date.

Thanks & Regards

Jeba

albi_prakash
Creator II
Creator II

Okay, I guess you will have the days only when the sales happened? If I am right you can use Count(Days) for the month. You may need set analysis for this

jebamalai
Specialist
Specialist
Author

Hi,

The attachment will give you more details about my requirement.

Overall Sales Based on Billing Days is the desired output.

Kindly let me know if you need more detail

Regards

Jeba

jebamalai
Specialist
Specialist
Author

Hi Team,

Can any one help me in this scanario.

Thanks & Regards

Jeba

jebamalai
Specialist
Specialist
Author

Hi Team,

Can any one help me in this scanario.

Thanks & Regards

Jeba