Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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.