Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sayalirandive906
Contributor II
Contributor II

Create a master measure for continuous date ranges

Hello Qlik Community, 
I have a date field named 'Date' in the format YYYY-MM-DD and measure field 'Amount'. I want to create a bar chart. The puzzle here is that, suppose that the user selects a date range between 15th May 2023 to 15th Jan 2023 Then I want to show the bars in the following format Bar 1 - Sum (Amount) on 15th of May 2023 Bar 2 - Sum (Amount) on 31st May - Sum (Amount) on 15th May Bar 3 - Sum (Amount) on 30th June - Sum (Amount) on 31st of May Bar 4 - Sum (Amount) on 31st of July - Sum (Amount) on 30th of June And so on until the last bar is Last Bar - Sum(Amount) on 31st of Dec - Sum (Amount) on 15th of Jan 2024. 

Could you help me understand how this can be achieved. 

Thanks and Regards, 
Sayali

Labels (1)
2 Replies
mruehl
Partner - Specialist
Partner - Specialist

Coudl you please provide some example data and define the desired output with a picture?

Anil_Babu_Samineni

@Sayalirandive906 If i understand correctly, You want one bar graph based on selection that input by users.

An example, If user select between 15th Jan 2023 to 15th May 2023. 

you want to have bar graph with. from Max selected date (15th May 2023) and the rest of year from selected date with month end date only, Example, since the user selected 15th May - You want 15th May, and End of month data for May, Jun, Jul ----- Dec?

 

If that is requirement, Do you have the data already for rest of the dates from selected date? 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful