Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello ,please help me
hi,
pls provide some sample in excel.
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
Hi,
PFA.
Regards,
Joshua.
Hi,
You could use the slider object however not for every day but a month-year combination.
Hello Joshua,
I cannot find any attachment
Hi,
PFA
what is the logic to find the Closed order?