Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
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'