Hi Guys,
I am new to qlikview.
i unable to achieve the requirement below.
i need to get the below eid event for 2020 year. but it is coming under 2019 in the below attached pivot table.
and also i need to get the cumulative numbers for months instead of names like jan as 1, feb as 2 and so on and for 2020 jan i need to get 13 and feb 2020 as 14.
below is the sample data.
| Regoin | sub region | stardate | end date | event |
| ams | us | 3/1/2019 | 4/2/2019 | diwali |
| ams | ca | | | |
| ams | cp | | | |
| ams | cr | 6/10/2019 | 7/8/2019 | function |
| ams | br | | | |
| ams | hy | | | |
| ams | cc | | | |
| ams | ff | | | |
| emea | hh | 1/12/2020 | 2/14/2020 | eid |
| emea | uu | 9/12/2019 | 10/14/2019 | bakdrid |
| emea | ff | | | |
| apj | ee | 11/4/2019 | 12/6/2019 | newyear |
| apj | ind | | | |
| apj | mys | | | |
| apj | japn | 1/3/2019 | 2/15/2019 | christmas |
i need to get as below. in the pivot table
| | year | 2019 | 2020 | | | | |
| quater | Q1 | Q2 | Q3 | Q4 | | | | | |
| Regoin | Month | Jan | Feb | Mar | Apr | Jun | Jul | Sep | Oct | Nov | Dec | jan | feb | march | | |
| | | 1 | 2 | 3 | 4 | ? Where is may | 7 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | | |
| ams | | - | - | diwali | diwali | function | function | - | - | - | - | | | | | |
| apj | | christmas | christmas | - | - | - | - | - | - | newyear | newyear | eid | eid | | | |
| emea | | - | - | - | - | - | - | bakdrid | bakdrid | - | - | | | | | |
Can any one please help me to achieve this.
