Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how to show data for terminated contracts in chart

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

Tags (1)
10 Replies
Not applicable

Re: how to show data for terminated contracts in chart

Hello ,please help me

ajsjoshua
Contributor III

Re: how to show data for terminated contracts in chart

hi,

pls provide some sample in excel.

Not applicable

Re: how to show data for terminated contracts in chart

Not applicable

Re: how to show data for terminated contracts in chart

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 idorder sign dateorder startdateorder enddate
131.02.201402.02.201410.03.2014
201.04.201404.04.201420.04.2014
303.03.201510.03.201520.03.2015
410.01.201616.01.201620.01.2016

Thanks Jaya

ajsjoshua
Contributor III

Re: how to show data for terminated contracts in chart

Hi,

PFA.

Regards,

Joshua.

anagharao
Contributor II

Re: how to show data for terminated contracts in chart

Hi,

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

Not applicable

Re: how to show data for terminated contracts in chart

Hello Joshua,

I cannot find any attachment

ajsjoshua
Contributor III

Re: how to show data for terminated contracts in chart

Hi,

PFA

Re: how to show data for terminated contracts in chart

what is the logic to find the Closed order?

Community Browser