Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Deepak87
Partner - Contributor III
Partner - Contributor III

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

reference screenshot.

Deepak87_0-1627142935082.png

 

 

0 Replies