how to show data for terminated contracts in chart

[#1]

Hello All,

I am stuck in one thing.

I want to show the contracts which have ended when we select a particular data range.

we have contractstartdate and contractenddate columns for contract ids.

how can i write the expression for this.

please help me as i have just started working on qlikview.

Thanks for your help.

Jaya

[#2]

Hello ,please help me

[ajsjoshua]

hi,

pls provide some sample in excel.

[#4]

Creating Reference Dates for Intervals

[#5]

Hello Joshua,

Thanks for replying.

This is data set examples..my calender is based on sign_date.now i want to show the records for the orders which have already ended in the straight table.Hope this makes sense.

order id	order sign date	order startdate	order enddate
1	31.02.2014	02.02.2014	10.03.2014
2	01.04.2014	04.04.2014	20.04.2014
3	03.03.2015	10.03.2015	20.03.2015
4	10.01.2016	16.01.2016	20.01.2016

Thanks Jaya

[ajsjoshua]

Hi,

PFA.

Regards,

Joshua.

[anagharao]

Hi,

You could use the slider object however not for every day but a month-year combination.

[#8]

Hello Joshua,

I cannot find any attachment

[ajsjoshua]

Hi,

PFA

[Kushal_Chawda]

what is the logic to find the Closed order?