Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis problem

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?

1 Solution

Accepted Solutions
Not applicable
Author

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))


View solution in original post

2 Replies
Not applicable
Author

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))


Not applicable
Author

Wow, works perfectly. Many thanks.