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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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