Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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: 
ofalana1674
Contributor
Contributor
‎2018-01-29 12:45 PM

Add Weekend Data to Next Weekday

I have a table that shows daily payment data. Is there a way to add data that falls on Saturday and Sunday to Monday's data? Please see sample below:

                             Date           Count               $Amount

Monday                1/22             120                    5,000

Tuesday                1/23            241                   6,750

Wednesday           1/24            92                     3,442

Thursday               1/25           103                    4,800

Friday                    1/26           300                   10,000

Saturday                1/27            25                      900  

Sunday                  1/28            14                     250 

Monday                  1/29           190                    7,000

...

...

I want to add data for Saturday (1/27) and Sunday (1/28) to the Monday (1/29), so that monday shows as:

                            Date           Count               $Amount

Monday                1/29             229                    8,150

371 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2018-02-01 12:57 PM

In the script or on the chart? Can you share a sample to show how this all is laid out?

342 Views
0 Likes