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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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?