Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-01-07 11:26 AM

dates calcultion

hi experts,

i have two tables like below i want last 3 days(without holidays) and 5 days(without holidays) as a separate buckets.when ever i click 3 days bucket or 5 days bucket it has to display last 3 days sales or 5 days sales in bar chart.

in billing day 1-working day 0-holiday,

can you please help me...

   

DateSalesCountry
1-Apr-154566.24Germany
2-Apr-154122.30Germany
3-Apr-154185.72Germany
4-Apr-155073.60Germany
5-Apr-15951.30Germany
6-Apr-154566.24Germany
7-Apr-154724.79Germany
8-Apr-153963.75Germany
9-Apr-154230.11Germany
10-Apr-154299.88Germany
11-Apr-155073.60Germany
12-Apr-15317.10Germany
13-Apr-153963.75Germany
14-Apr-153963.75Germany
15-Apr-154724.79Germany
16-Apr-153963.75Germany
17-Apr-154230.11Germany
18-Apr-151458.66Germany
19-Apr-151204.98Germany
20-Apr-154724.79Germany
21-Apr-153963.75Germany
22-Apr-154230.11Germany
23-Apr-154724.79Germany
24-Apr-153963.75Germany
25-Apr-151426.95Germany
26-Apr-15780.07Germany
27-Apr-154724.79Germany
1-Apr-155288.40UK
2-Apr-154774.25UK
3-Apr-154847.70UK
4-Apr-155876.00UK
5-Apr-151101.75UK
6-Apr-155288.40UK
7-Apr-155472.03UK
8-Apr-154590.63UK
9-Apr-154899.12UK
10-Apr-154979.91UK
11-Apr-155876.00UK
12-Apr-15367.25UK
13-Apr-154590.63UK
14-Apr-154590.63UK
15-Apr-155472.03UK
16-Apr-154590.63UK
17-Apr-154899.12UK
18-Apr-151689.35UK
19-Apr-151395.55UK
20-Apr-155472.03UK
21-Apr-154590.63UK
22-Apr-154899.12UK
23-Apr-155472.03UK
24-Apr-154590.63UK
25-Apr-151652.63UK
26-Apr-15903.44UK
27-Apr-155472.03UK

2nd table

   

DateBilling DayCountry
1-Apr-151Germany
2-Apr-151Germany
3-Apr-151Germany
4-Apr-150Germany
5-Apr-150Germany
6-Apr-150Germany
7-Apr-151Germany
8-Apr-151Germany
9-Apr-151Germany
10-Apr-151Germany
11-Apr-150Germany
12-Apr-150Germany
13-Apr-151Germany
14-Apr-151Germany
15-Apr-151Germany
16-Apr-151Germany
17-Apr-151Germany
18-Apr-150Germany
19-Apr-150Germany
20-Apr-151Germany
21-Apr-151Germany
22-Apr-151Germany
23-Apr-151Germany
24-Apr-151Germany
25-Apr-150Germany
26-Apr-150Germany
27-Apr-151Germany
28-Apr-151Germany
29-Apr-151Germany
30-Apr-151Germany
1-Apr-151UK
2-Apr-151UK
3-Apr-151UK
4-Apr-150UK
5-Apr-150UK
6-Apr-151UK
7-Apr-151UK
8-Apr-151UK
9-Apr-151UK
10-Apr-150UK
11-Apr-150UK
12-Apr-150UK
13-Apr-151UK
14-Apr-151UK
15-Apr-151UK
16-Apr-150UK
17-Apr-151UK
18-Apr-150UK
19-Apr-150UK
20-Apr-151UK
21-Apr-151UK
22-Apr-151UK
23-Apr-151UK
24-Apr-151UK
25-Apr-150UK
26-Apr-150UK
27-Apr-151UK
28-Apr-151UK
29-Apr-151UK
30-Apr-151UK
392 Views
0 Likes
4 Replies
MarcoWedel
MVP
MVP
‎2016-01-07 07:50 PM

please post your expected result.

thanks

regards

Marco

246 Views
0 Likes
MayilVahanan
MVP
MVP
‎2016-01-08 12:39 AM

Hi

PFA

Did the script step by step for understanding purpose.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Comm_198765.qvw
246 Views
0 Likes
amit_saini
Master III
Master III
‎2016-01-08 12:47 AM

Hi Siva,

Check:

Find Net Working Days

Thanks,
AS

246 Views
0 Likes
Not applicable
‎2016-01-08 03:30 AM
Author

In response to MarcoWedel

in list box

bucket3

bucket5

when ever click in the bucket need to  show last 3days sales in bar charts

246 Views
0 Likes