Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Deepak87
Partner
Partner

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