topic Set analysis problem in QlikView

Set analysis problem

Thu, 21 Oct 2010 20:50:06 GMT

Hi,

I need to set Jun-2010 forecast value for all Months. I have pivot table with only one dimension - MonthYear. If I use set analysis formula

sum ({$<MonthYear= {'Jul-2010'} >} Forecast))

my table shrinks to only one row for Jul-2010. I would rather expect all 12 months with one Forecast value (for Jul-2010). Help please.

Micha?

Set analysis problem

Thu, 21 Oct 2010 21:09:44 GMT

Could you give some more info on your data structure? The results you describe are the results I would expect from that expression. Sum of Forecast for only Jul-2010. With Month-Year as dimension, that's one line for Jul-2010 only.

Do you have multiple date fields in your data set? You say 12 months with Forecast date of Jul-2010. What is Forecast date and where do the 12 months come in in relation to the single Forecast month.

Do you want to see all 12 months in your dataset, but show all the same value? If so, then you may want:

sum ({$<MonthYear= {'Jul-2010'} >} TOTAL Forecast))

Set analysis problem

Thu, 21 Oct 2010 21:20:21 GMT

Wow, works perfectly. Many thanks.