Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pagiamol
Contributor III
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.

0 Replies