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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Raya
Contributor II
Contributor II

Need help to load specific quarter data into specific quarter app from year QVD

Hello Qlik Experts,

I need some help in reading the data from QVD where i have one year of data.

i have 4 apps, each app should have quarter wise data. i need  a help to write condition in the qvd where class so that  only that specific quarter will be loaded into app from qvd on every day app refreshes 

like JAN 2024- march 2024 in one app, april 24 to jun 24 , jul24 - sep24 and finally oct24 - Dec 24.

 

 Regards,

khadar

Labels (1)
1 Reply
shraddha_g
Partner - Master III
Partner - Master III

You can set conditions on Date available in QVD like

For Quarter 1

Date >= 1/1/24 and Date <=31/3/24

For Quarter 2

Date >= 1/4/24 and Date <=30/6/24

For Quarter 3

Date >= 1/7/24 and Date <=31/9/24

For Quarter 4

Date >= 1/10/24 and Date <=31/12/24