Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

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

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

1 Solution

Accepted Solutions
ogautier62
Specialist II
Specialist II

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

View solution in original post

4 Replies
ogautier62
Specialist II
Specialist II

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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
Specialist II
Specialist II

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'