topic Re: User Date selections for Set Analysis not adequate..need help in QlikView

User Date selections for Set Analysis not adequate..need help

Mon, 29 Apr 2013 16:34:19 GMT

I have a Set Analysis expression that works great under strict circumstances.

This sums up a Date Range from Min to the Max Months selected. or Max(RevMonth)

Sum({$<RevMonth={"$(='>=' & Min({$} RevMonth) & '<=' & AddMonths(Min(RevMonth),MonthDiff) )"}>} RevAmt)

The problem is if a user selects Non Consecutive months then the calculation is wrong or sums up to much because it does not take into account the 'missing' months. Is there a better way to handle this situation.? What I'm I doing wrong ?

Thank You all,

Brian

Re: User Date selections for Set Analysis not adequate..need help

m_woolf — Mon, 29 Apr 2013 16:44:42 GMT

Can you use max(RevMonth) instead of

AddMonths(Min(RevMonth),MonthDiff)

Re: User Date selections for Set Analysis not adequate..need help

Mon, 29 Apr 2013 17:11:16 GMT

Yeah I've tried that, but gets me the same result. I may have to provide all the possible month possiblities up to 20 or so. too much work but may require that or force them to only select Consecutive months which is how most would any ways.

Re: User Date selections for Set Analysis not adequate..need help

johnpaul — Mon, 29 Apr 2013 17:51:18 GMT

I don't let the user select multiple months.

I use a variable and a calendar object to allow the user to select an end date. Then another variable to select the start date.

Re: User Date selections for Set Analysis not adequate..need help

Mon, 29 Apr 2013 18:01:17 GMT

I think that is the way I will have to do it to control the data flow into the Expression.

Does it allow user to see whats green,grey white, I guess that implied once selected...

Thank you both for your insights, tips & advice.

Re: User Date selections for Set Analysis not adequate..need help

Mon, 29 Apr 2013 18:26:35 GMT

Paul, could you upload a sample of this calendar method with variables or point me to a online example.? Thanks!

Re: User Date selections for Set Analysis not adequate..need help

kaushiknsolanki — Mon, 29 Apr 2013 18:46:10 GMT

Hi,

Have a look at the attachment.

Regards,

Kaushik Solanki