Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Kdtv1977
Contributor
Contributor

Condition based on dates

Hello,

I have a question with regards to (a combination of) dates. Let's say I have 2 dates field (posting date and entry date) and I want to show only the values whereby posting date < entry date. I want to use this new date/variable as input for a date picker e.g. . 

Thanks in advance,

 

Labels (2)
3 Replies
ajaykakkar93
Specialist III
Specialist III

Hi,

i think you can do it via back end if you can share a example application i might be able to help you.

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

Michelle140
Contributor
Contributor

Yes it is easily possible via back end..Yes example would make it easy to solve myccpay

Kdtv1977
Contributor
Contributor
Author

Hello Ajay, Michelle,

Sorry for the delayed response. Well in Qlikview I used a trigger to filter 2 date fields base on a date field but in Qlik Sense (to my knowledge) triggers don't exist. 

So how do I filter then the total revenue e.g. with one date (let's say entry date) field (in a calender) when entry date > entry date selected via calender and entry date < (less then) shipment date?

In the formula itself then of the chart if i understand it correct?

Thanks in advance,

 

Kris