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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression for date difference in selected date DB date and display in a particular column

HI,

I have columns for a range like 0-30,31-60,61-90 like this and depending upon date difference that is difference between selected date and batch date i want to show qty int that columns.

how to write expression for that.

QlikTech Admin

2 Replies
Not applicable
Author

Please upload a sample document. Will make our understanding of how to write the expression a lot easier.

Right now there are many ways to do this

Script - IntervalMatch()

Front - Class(), Set Analysis ({<Date={'<=$(=BatchDate)'}>}) et cetera

Cheers,

Byron

Not applicable
Author

Can you upload a sample app with small data?