Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Incremental Load - Show only Months No Quarters

Hi All,

Dealing with strange  scenarios in Incremental Load for our Project.

We have following kind of Data.


ProcessID    ProcessDate      Metrics          Dimensions

1                        2016-01-01

2                        2016-02-01

3                        2016-03-01

4                        2016-04-01

5                        2016-05-01

6                        2016-06-01

7                        2016-0701

and so on till December and continued till 2017 Feb

Here, 3,6,9 and 12 means  Quarter as in Q1,Q2,Q3,Q4.

1. Scenario 1 ---- I need to show only Months data i.e. 1,2,4,5,7,8,10,11

2. Scenario 2 --- need to show only last Quarter means Q4 of any available Year in QVD it could be  2015, 2016 (history QVD already created) and 2017 data is in database.

Kindly help.

Looking forward for valuable inputs.