Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

manoj217
Contributor II

Calender Dates

Hi all

i have a calender object in my dashboard and i have 2 date fields like paid date and received date.

Now i am created a calender object based on paid date but user mentioned if he selects a start date in the object it should shows the data from 7 days before of his selection so i mentioned (paid date)-7 its working fine  but he mentioned received date data should be in the range of his selection only

example:

if i select date range 7/10/2018 means paid date data should be 1/10/2018

but received date data in 7/10/2018 to current date only

12 Replies
manoj217
Contributor II

Re: Calender Dates

One calendar dependent on two fields is possible

can we create a calender object on two variables for start date and end date ?

Re: Calender Dates

Play around using MonthStart(DateField) from Object expression?

manoj217
Contributor II

Re: Calender Dates

sorry it will not work my requirement is different

i have calender object if we select any date document will hold the data regarding those selections.

but if user select today as min date but i have to show before 7 days data it is working. it is created on one field payment date

but now i want to show the data on current selected date in another field received date

Re: Calender Dates

Can you give sample data, Explain please for me?

manoj217
Contributor II

Re: Calender Dates

paid date     received date

10/12/2018     12/12/2018

13/12/2018     14/12/2018

14/12/2018     16/12/2018

15/12/2018     18/12/2018

17/12/2018     20/12/2018

20/12/2018     25/12/2018

if user selects a date 20/12/2018 but in document shows  data from 14/12/2018 -----this data from paid date field

that means

14/12/2018     16/12/2018

15/12/2018     18/12/2018

17/12/2018     20/12/2018

20/12/2018     25/12/2018

this data will show in output but i want to show only

17/12/2018     20/12/2018

20/12/2018     25/12/2018

Re: Calender Dates

You can try this way? Where as your problem comes thru Calendar. Better if you can share sample application


If([paid date] >= [receive date], [paid date])

uacg0009
Valued Contributor

Re: Calender Dates

Hi manoj,

do you mean when you select 20/12/2018,

you want to show all the results that paid date >= 14/12/2018 and received date >= 20/12/2018?

if yes, I can handle this. if no, please help to clarify the logic.

Thanks.

Aiolos

bvssudhakar
Contributor

Re: Calender Dates

Hi Manoj,

Can you share your qvd. so that i will try to solve your issue

Thanks & Regards,

Sudhakar

manoj217
Contributor II

Re: Calender Dates

Yes Zhao your assumption is correct i want the same

Community Browser