Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
see attached (with cumulative value for month!)
see attached (with cumulative value for month!)
Thank you so much Frank.
please close this thread by marking the correct answer!