Set Analysis Headache!

Mon, 22 Jul 2013 13:43:13 GMT

Hi,

I have a weird problem that has been troubling me for a few days now. My output is to show the current month’s totals to the previous months, as well as the current month from the previous year. If you see in the attached example, I have selected Dec 2012 from the YEAR and MONTH Listboxes. The values for the selected month show without any problems BUT I can’t see the previous month and current month previous year's totals.

I’m using set analysis to get these values and control the months using variables (shown on the side of the table as well).

This is how I get my values and the variables:

Current Month: SUM({$<MonthDate={'$(vMonth)'}>} OperationalTrendTotal)

Previous Month: SUM({$<MonthDate={'$(vPreviousMonth)'}>} OperationalTrendTotal)

Current Month Previous Year: =SUM({$<MonthDate={'$(vPreviousYearCurrentMonth)'}>} OperationalTrendTotal)

vMonth =Date(MonthDate, 'YYYY-MM-DD')

vPreviousMonth =Date(AddMonths(MonthDate,-1), 'YYYY-MM-DD')

vPreviousYearCurrentMonth =Date(AddMonths(MonthDate,-12), 'YYYY-MM-DD')

Re: Set Analysis Headache!

kaushiknsolanki — Mon, 22 Jul 2013 13:46:39 GMT

Hi,

For previous month try this.

SUM({$<MonthDate={'$(vPreviousMonth)'},Year = , Month =>} OperationalTrendTotal)

When ever you are trying to get the data for against the selection, you must remove the selection as I have shown in above expression.

Regards,

Kaushik Solanki

Re: Set Analysis Headache!

Mon, 22 Jul 2013 15:01:56 GMT

Hi Kaushik,

Thank you, that was correct!

topic Re: Set Analysis Headache! in QlikView

Set Analysis Headache!

Re: Set Analysis Headache!

Re: Set Analysis Headache!