Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pinky1234
Contributor III
Contributor III

Need Previous Quarter data

Hi,

Load * from Table

where SubmitDate >='2021-07-01' and SubmitDate<='2021-09-30';

when I hard code the dates like this it is working as expected. I want this date to work dynamically like I should get dynamically get previous quarter data . Now Quarter 3 data ,Next Jan 1-2022  I should get 4th quarter data dynamically. Can some one help me with the formula? 

 

Thanks in adavance!

2 Replies
Or
Master III
Master III

You asked this just yesterday, and never responded to the suggested solution...

https://community.qlik.com/t5/New-to-Qlik-Sense/I-need-help-to-get-last-quarter-data-dynamically/m-p...

pinky1234
Contributor III
Contributor III
Author

Yesterday's solution didnt work as expected. I tried to use in my where condition SubmitDate BETWEEN ('$(vStartDate)' and '$(vEndDate)')and it didnt work. If i go and see my report submit date and i am seeing all dates unders submit date instead of 07/01 to 09/30 2021. I am looking for other solution which works in my scenario. Thanks!