i am new to qlikview . unable to acheive the following requirement . can anyone help me out.
Here i attached the requirement needs to be achieved and below is the sample data.
Regoin
sub region
Eventstartdate
Eventend 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
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
Based on the region and sub region i need to show the events happened with highlighted color and in the pivot table with the event start date and event end date.
For example if the event happened on 1/3/2019 to 2/15/2019 it shouls show in the pivot table under 2019 year ,Q1,Jan to feb with the christmas as highlighted.
