Calculating pivot table column differences

Tue, 27 Aug 2013 17:32:42 GMT

Sorry for poor title. Here is what I'm trying to do:

I have data that looks like this:

Measure, Denominator, Numerator, Excluded, FileName

What I want to do is show the following:

MeasureA, DenominatorFileNameA, NumeratorFileNameA, ExcludedFilenameA, MeasureA, DenominatorFileNameB, NumeratorFileNameB, ExcludedFilenameB, DenominatorFileNameB - DenominatorFileNameA, NumeratorFileNameB - NumeratorFileNameA, ExcludedFilenameB - ExcludedFilenameA

I have been able to get close using a pivot table to get me the info by Filename but I cannot see a way to take the difference.

I have also tried this doing a straight table and loading the raw data twice with different fields aliases, etc. but filtering didn't work correctly.

Many thanks in advance for advice.

Re: Calculating pivot table column differences

Wed, 28 Aug 2013 13:11:38 GMT

So maybe some additional information will help. I also realize that the formatting did not come through correctly when I pasted it in the message before.

So my data has five columns:

Measure, denominator, numerator, excluded and filename.

The filename is loosely associated with a date but is not regular so here are some examples:

20130515_serverA
20130424_serverA
20130316_serverA
Etc.

What I want to be able to do is compare statistics between files and I want the user to be able to select any two files to compare. So, for example, a user would select 20130424_serverA and 20130515_serverA to compare and would then see the following columns:

Measure, 20130424_serverA denominator, 20130424_serverA numerator, 20130424_serverA excluded, 20130424_serverA rate (numerator divided by denominator), 20130515_serverA denominator, 20130515_serverA numerator, 20130515_serverA excluded, 20130515_serverA rate, and also have columns with deltas such as the difference between denominators, numerators, excluded and rates between the two files.

Is this possible? Is it better to do in data load or in pivot, or in straight table, or via set analysis, etc. Any feedback would be appreciated. Many thanks again in advance.

topic Calculating pivot table column differences in QlikView

Calculating pivot table column differences

Re: Calculating pivot table column differences