Set default option to "Total" in report builder style pivot table

[helen_pip]

Dear Qlikview user

I have created an inline statement which is being used as a list box and I have 3 columns in my inline

LOAD * INLINE [_dimensionNo_OP, _dimension_OP

1, Division,

2, Care Group,

3, Total;

I then created a "Report Builder" pivot table where the dimensions have an enabled condition so when the user selects Division, the pivot table will populate values by Division

My enabled condition is:

SubStringCount(Concat(_dimension_OP, '|'), 'Division')

What I am trying to Achieve

What I am trying to achieve is if the end user unselects the Division option, then the pivot table should default to show the Total option

So far I have come up with the following enabled condition, but seem to not be able to progress. Could someone kindly help me progress this statement

=If(IsNull(SubStringCount(Concat(_dimensiion_OP, '|'), 'Division')) , SubStringCount(Concat(_dimension_OP, '|'), 'Total'))

Any help or advice would be greatly appreciated

Kind Regards

Helen

[ogautier62 · Accepted solution]

Hi,

you could too try something like this :

in dimension :

if(getselectedcount("dimension")>0, if( getfieldselections('dimension') <> 'total',$(= getfieldselections("dimension")), ),)

that works on my sample test

regards

[helen_pip]

Hi Olivier

Thank you for your suggestion I have placed this enable condition on my dimension and replaced the blanks with what I needed and I think it works

Thank you very much

Kind Regards

Helen

[helen_pip]

Dear Olivier

Thank you for your time and this suggestion does work but what if I take my selection off "Total" THEN pick a dimension and THEN take the dimension off. 

How could I get Total to be the default option without reverting to the Error messages

Kind Regards

Helen

[ogautier62]

Helen,

look at response in your other post,

I think you can manage with actions (at opening sheet) :

you choose action 'select in field'; field 'dimension' ; text : 'total'