topic show associated date range for each variable in QlikView

show associated date range for each variable

Thu, 15 Oct 2009 03:49:18 GMT

Hi, I have 3 ("customers") that have purchase data in different ranges of dates. I would like to have a list box that shows me the range of dates associated with the customer selected.

Similarly, I would like to check for min/max values (range) of product volume to ensure no negative values and to have a box that reports that info for all or each of the respective date ranges. In a sense, this would serve as error reporting for the input side.

Thanks in Advance.

show associated date range for each variable

rwunderlich — Thu, 15 Oct 2009 10:15:52 GMT

Are you sure you want a listbox? I would normally do this with a Straight Table Chart with a dimension of Customer and two expressions, "max(date)" and "min(date)".

Or if you want to show the complete range for all selected customers, a textbox with the expression =min(date) & " " & max(date).

-Rob

show associated date range for each variable

Mon, 19 Oct 2009 22:01:36 GMT

Rob,

Thanks, I ended up doing a straight table for this just as you suggested. Thank you for your reply.