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
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
wiz_nerd
Creator
Creator

Create Qvd to store all current month dates till today but for all previous months only month end dates.

Note : I have complete data range from 1/1/2020 till today 6/1/2021 shown below

Input Date Range 

01/01/2020

till

06/01/2021

and I just want to store the values in QVD shown in the Image

Current month all dates till today and previous months only Month End values.

Output Required:

datex.JPG

and store in qvd.

@sunny_talwar  @rbecher  @Gysbert_Wassenaar@rwunderlich@bill_markham@nicolett_yuri@jagan@maxgro@stevedark@Peter_Cammaert

 

Labels (5)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try using a where clause like:

WHERE 
SnapshotCFT >=MonthStart(Today()) and SnapshotCFT<=Today()
or
(SnapshotCFT <=Today() and Floor(SnapshotCFT)=Floor(MonthEnd(SnapshotCFT)));

View solution in original post

2 Replies
tresesco
MVP
MVP

Try using a where clause like:

WHERE 
SnapshotCFT >=MonthStart(Today()) and SnapshotCFT<=Today()
or
(SnapshotCFT <=Today() and Floor(SnapshotCFT)=Floor(MonthEnd(SnapshotCFT)));

View solution in original post

wiz_nerd
Creator
Creator
Author

Thanks @tresesco , for your time.