Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jebamalai
Valued Contributor

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
Contributor II

Re: Sales Variation Based on Billing Days

Hi,

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

-Jay

jebamalai
Valued Contributor

Re: Sales Variation Based on Billing Days

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
Contributor II

Re: Sales Variation Based on Billing Days

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
Valued Contributor

Re: Sales Variation Based on Billing Days

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
Valued Contributor

Re: Sales Variation Based on Billing Days

Hi Team,

Can any one help me in this scanario.

Thanks & Regards

Jeba

jebamalai
Valued Contributor

Re: Sales Variation Based on Billing Days

Hi Team,

Can any one help me in this scanario.

Thanks & Regards

Jeba