Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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?