Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
arusiva89
Contributor III
Contributor III

Tricky Question

My requirement is a little bit tricky . Kindly help me to achieve that

I have a date selector and  When a user selects a date range in the selector, I should show the Current Month vs Previous Month data. Suppose If a user selects Jan 15 - Apr 15 in the date selector, My table should look like this 

arusiva89_0-1597249631907.png

 

2 Replies
Anil_Babu_Samineni

What are the "1-15" and "1-29" etc? And you want this in tabular?

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
arusiva89
Contributor III
Contributor III
Author

Sorry, there was a mistake in the snapshot, If a user selects a date range from Jan 15- April 15  then I have to show the value for the period Jan 15-31 in the current month and Dec 15-31 in the previous month. In the second row Feb 1-29 values int the current period and Jan 1-31 in the previous month and goes on like that till the selected period