Set Analysis possible for date by Dimension?

Thu, 10 Sep 2015 21:01:28 GMT

Is it possible to use set analysis with a date range that varies by dimension? I'm doing a report on campaign response and the user wants to be able to adjust the response window after the campaign start date. I have input fields that write to variables, which are embedded in other variables to add the input field values to the campaign start date (vMinResponseDate = [Campaign Start Date]+vMinResponseWindow).

I put that calculated date variable in the chart to verify it's returning the correct date, but when i try to use that calculated date variable in the set analysis of the expression to count the responses:

Count({< [Interaction Date] = {'>$(date(vMinResponseDate))<= $(date(vMaxResponseDate))'}>} ADDR_ID) it's not returning the right result.

The way i have it configured in the attached doc, it's currently returning a value that's roughly double the accurate count.

Is there another approach i should use, or a change i can make to the expression that would make it work right?

Re: Set Analysis possible for date by Dimension?

Gysbert_Wassenaar — Fri, 11 Sep 2015 05:45:48 GMT

The set is calculated at the chart level, not at the Campaign level like you need. You can use an if-statement instead. Count( If( [Interaction Date] >$(vMinResponseDate) and [Interaction Date] <= $(vMaxResponseDate), ADDR_ID)).

topic Re: Set Analysis possible for date by Dimension? in QlikView

Set Analysis possible for date by Dimension?

Re: Set Analysis possible for date by Dimension?