topic Re: Drill Dimension with Set Analysis in QlikView

Drill Dimension with Set Analysis

Mon, 23 Sep 2013 14:53:16 GMT

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
)

Re: Drill Dimension with Set Analysis

datanibbler — Mon, 23 Sep 2013 15:25:51 GMT

Hi desmiddleton,

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

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

HTH

Best regards,

DataNibbler

Re: Drill Dimension with Set Analysis

Mon, 23 Sep 2013 15:41:54 GMT

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
)

Re: Drill Dimension with Set Analysis

Josh_Good — Mon, 23 Sep 2013 15:58:58 GMT

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)

Re: Drill Dimension with Set Analysis

Mon, 23 Sep 2013 17:38:03 GMT

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.

Re: Drill Dimension with Set Analysis

Mon, 23 Sep 2013 17:39:04 GMT

I already have fuelGroup in the set analysis.

Re: Drill Dimension with Set Analysis

Mon, 23 Sep 2013 17:40:09 GMT

I already have AspectName in the set analysis.