Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Kumar6872
New Contributor

Quarter Display

Hi All,

 

I need to display my data as how many items got delivered for that product in that quarter of the year
for example if 2 Product A were delivred in March of that year we need to display count 2 in Q1 of that year.

Here is the sample data
Year   Product    DeliveryDate               Status
2018         A               Jan 1 2018             InTransit
2018         A                Feb 10 2018         Delivered
2018         B                Jan 1 2018           InTransit
2018         A                  Mar 1 2018         Delivered
2018         B                 Mar 10 2018       Delivered
2018         B               May 10 2018        Delivered

2019        A                Oct 10 2019          InTransit
2019        A                 Oct 20 2019         Delivered
2019        B                 Nov 21 2019        InTransit
2019         B                NOv 13 2019       Delivered
2019         B               Dec 16 2019        InTransit
2019        B                Dec 19 2019      Delivered


Display the products count delivered in the respective quarter

Year              Product          Q1      Q2          Q3         Q4
2018                  A                     2
                            B                    1           1

2019                   A                                                              1
                             B                                                              2

 

 

Thanks in advance

1 Solution

Accepted Solutions
Partner
Partner

Re: Quarter Display

1 Reply
Partner
Partner

Re: Quarter Display