Fast Change

[#1]

Hi all,

I have created an Inline function

Load * Inline [

Dimension

Underwriter

Underwriter To Sector

Trade Sector

SecToUnd

];

I am using this in a chart conditionally. When i select Underwriter, dimension of the chart should be Underwriter.

When i select 'Underwriter to Sector' it should select a drill down dimension i.e 'Underwriter to Sector'

I have used =SubStringCount(Concat(Dimension, '|'), 'Underwriter') for Underwriter

and =SubStringCount(Concat(Dimension, '|'), 'Underwriter to Sector') for Underwriter to Sector.

But its not coming properly. I know the reason this is because of the substringcount considers underwriter in both the cases.

Please help me how to solve this.

I have attached the QVW. Please look into it.

Thanks in advance,

Keerthi

[jonathandienst]

=SubStringCount(Concat(Dimension & '@', '|'), 'Underwriter@')

Keerthi K S wrote:

Thanks Gysbert.

But it looks odd in the front end displaying Underwriter@

Just add a PurgeChar:

=PurgeChar(SubStringCount(Concat(Dimension & '@', '|'), 'Underwriter@'), '@')

HTH

Jonathan

[#3]

Its not working in my case.

[#4]

I tried this but its the same.

[#5]

Its still not working.

[stabben23]

Is it working if you remove your drill down dimensions? And remember the spelling inside the Enable Conditional.

//Staffan

[#7]

I changed the inline function with double quotes and also in the ENABLE CONDITIONAL.

But still its not working.

For drill down its coming only with Trade Sector. Underwriter is not coming.

Regards,

keerthi

[jagan]

Hi Keerthi,

It is working but the Drilldown Group icon is not displaying, since you have the same columns in the Group and Dimension you are not able to identify the column changes.  May be this is a bug.

Regards,

Jagan.

[#9]

can u please attach the qvw. I will look into it.

That is fine i dont want icon to be displayed

[Gysbert_Wassenaar]

The idea is to add the @ only in the substringcount expression. The actual values in the Dimension field are not changed.

[#11]

I tried using @Underwriter to Sector but there is another Field Sector .... When i used @Underwriter to Sector, both Underwriter to Sector drill down and also sector is selected.