Drill Dimension with Set Analysis

[#1]

I have a drill group dimension (contains FuelGroup and EntityName) in a chart. I am using the expression below to calculate the total generation by EntityName and FuelGroup. This expression seems to work fine when I have just one dimension (FuelGroup or EntityName). However, when using the grouped dimension a problem occurs when a user selects an AspectName that doesn't have a FuelGroup associated with it, I only see data by EntityName. How can I ignore the AspectName selections.

Sum

(
{$ < FuelGroup= E({1<FuelGroup={"Off System Sales"}>}),
EntityName = {"T_*","H_*"},
AspectName = {"Generation"},
RunLogID = {$(vCase1Selection)},
Iteration = {0} >}
Val
)

[datanibbler]

Hi desmiddleton,

using SET_analysis, that you are already using, you can specify, like,

<AspectName = >

That will ignore any selections on that particular dimension (see "QlikView 11 for Developers", if you have it).

HTH

Best regards,

DataNibbler

[#3]

The AspectName is not the problem since it is already in your set analysis,

Add FuelGroup =, so as

Sum

(
{$ < FuelGroup= E({1<FuelGroup={"Off System Sales"}>}),
EntityName = {"T_*","H_*"},
AspectName = {"Generation"},
RunLogID = {$(vCase1Selection)},
Iteration = {0},

FuelGroup=>}
Val
)

[Josh_Good]

I believe you will need to write a slight different expression depending on the state of the cycle.  You can use the get GetCurrentField function determine the state of the cycle and then have two expression in an if statement.

e.g.

if (GetCurrentField([CycleName] = 'FuelGroup',

     Expression1, Expression2)

[#5]

I was thinking the same thing, except my graph didn't calculate incorrectly when drill-down/up, only when I selected some other AspectName (which is not in the graph as a dimension), but I included the field in the set Analysis. So I think this is my problem, I have AspectNames that do not belong in any FuelGroup. I can put them in a group but it doesn't make sense to have them in any fuel group (eg. load has nothing to do with fuel). Is there anyway around having to do this? Or have to split load and generation data separately.

[#6]

I already have fuelGroup in the set analysis.

[#7]

I already have AspectName in the set analysis.