date range selection and string selection in straight table

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a date field Payment Date and i am created the calender object on top of the field.

Now user selects a date range from and to date through calender object

But the issue is Payment Date field having some nulls replaced with 'Not paid'. if user selects any date range that data should be visible+'Not paid' data is also visible for any date range selection.

For this scenario calender object will not select the string so i want to use this calender object for only to store date values in the variable

i want to use this variable in straight table expression.

now i need the expression based on my requirement.

that expression is having to select the data from with in a selected date range and also pick the string Not Paid

topic date range selection and string selection in straight table in QlikView

date range selection and string selection in straight table