Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manoj217
Creator III
Creator III

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
Creator III
Creator III
Author

One calendar dependent on two fields is possible

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

Anil_Babu_Samineni

Play around using MonthStart(DateField) from Object expression?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
manoj217
Creator III
Creator III
Author

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

Anil_Babu_Samineni

Can you give sample data, Explain please for me?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
manoj217
Creator III
Creator III
Author

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

Anil_Babu_Samineni

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])

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
uacg0009
Partner - Specialist
Partner - Specialist

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
Creator III
Creator III

Hi Manoj,

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

Thanks & Regards,

Sudhakar

manoj217
Creator III
Creator III
Author

Yes Zhao your assumption is correct i want the same