topic Set Analysis-Two Many Set Analysis in QlikView

Set Analysis-Two Many Set Analysis

Wed, 04 Aug 2010 03:10:42 GMT

Hi,All!

I,m from China.

I got a big problem.I have a big table which contains nearly 100 million data .This table contains all the purchase,sales,returns and other types data and they are separated by one field.So in my project almost every expression contains a set analysis.

I want to know using too many set analysis is good for my project or not!

Set Analysis-Two Many Set Analysis

Wed, 04 Aug 2010 06:01:20 GMT

Hi,

Usage of complex set analysis can cause server overhead sometimes. This is dependent on the complexity of the calculation and the volume of data involved in the set analysis.

I guess from your post that all your fact information are available in a single field 'SummaryID' and you are applying set analysis for every calculation you create. As a work around, try creating individual columns for each fact in script level (example: if(summaryID='Sales',value) as Sales and vice versa for other facts also)

Let me know if my understanding is wrong.

Cheers,

Haneesh

Set Analysis-Two Many Set Analysis

Wed, 04 Aug 2010 08:52:50 GMT

Thanks Haneesh?

I know what you mean and I will have a try!