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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
MVP
MVP

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