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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Athira_K
Contributor III
Contributor III

Extract data between 2 months given by the user

Hello
I have a graph plotted with 12 months on the x axis
I want to display data between 2 selected months alone
eg: If I select March and July, I want the data from March to July get plotted in the graph.
How can we do that?

1 Reply
MayilVahanan

HI Athira,

Try like below

If you have date field, try like below

Sum({<Date={">=$(=MonthStart(Min(Date)))<=$(=MonthEnd(Max(Date)))"}, Month=, Year=>}UrExp)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.