Qliksense bar chart for contract effective & Expiring date
Hi All,
I have a below set of data.
Contract Name
Contract Type
Effective Date
Expiration Date
Contract1
Amendment
2017-12-10
2021-12-10
Contract2
Other
2016-12-20
2021-12-19
Contract3
Amendment
2016-07-28
2021-07-27
Contract4
Order
2016-11-09
2021-10-30
Contract5
Maintenance
2016-09-20
2021-09-15
Contract6
Other
2016-08-31
2021-07-30
Contract7
Amendment
2020-07-31
2021-07-30
Contract8
Order
2018-11-30
2021-11-29
Contract9
Maintenance
2018-11-30
2021-11-29
Contract10
Other
2019-12-15
2021-12-14
Is it possible to create a view as below.
Should have contract name & type dimensions. Then Effective and Expiration date should shown in Bar with today as reference line and # no of days remaining to expire