topic Re: Fast Change in QlikView

Fast Change

Fri, 10 Jan 2014 07:07:59 GMT

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

Re: Fast Change

Gysbert_Wassenaar — Fri, 10 Jan 2014 07:10:31 GMT

Try adding an extra character like a @ to the values:

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

Re: Fast Change

Fri, 10 Jan 2014 07:21:11 GMT

Thanks Gysbert.

But it looks odd in the front end displaying Underwriter@

Re: Fast Change

Fri, 10 Jan 2014 07:28:19 GMT

Hi Gybert,

I am trying this script but Output Not exactly,

Dev01:

Load * Inline

[

Dimension

Underwriter

Underwriter To Sector

Trade Sector

SecToUnd

];

LOAD SubStringCount(Concat(Dimension & '@', '|'), 'Underwriter') as Underwriter Resident Dev01;

load SubStringCount(Concat(Dimension & '@', '|'), 'Underwriter To Sector') as Underwriter_To_Sector Resident Dev01;

Regards,

Raja.

Re: Fast Change

Fri, 10 Jan 2014 08:55:50 GMT

I tried this but nothing has changed

Re: Fast Change

jagan — Fri, 10 Jan 2014 09:05:35 GMT

HI,

Check this link hope it helps you.

Adhoc reporting in Qlikview

Regards,

Jagan.

Re: Fast Change

Fri, 10 Jan 2014 09:16:07 GMT

Hi Jagan,

Problem is when i have sub string names common. Here one is underwriter and Underwriter to Sector.

When i select underwriter to sector. Underwriter dimension is selected twice.

This should not happen

Thanks & regards,

Keerthi

Re: Fast Change

jagan — Fri, 10 Jan 2014 09:20:45 GMT

Hi,

Use expression like this

=SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|underwriter |')

=SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Underwriter to Sector|')

Hope this helps you.

Regards,

Jagan.

Re: Fast Change

Fri, 10 Jan 2014 10:24:06 GMT

Hi,

I use space in front, check attached app, it may help you

Regards

Re: Fast Change

stabben23 — Fri, 10 Jan 2014 10:33:28 GMT

Hi,

try to put a doublequote around your dimensions in the inline table: "Underwriter To Sector" ex

//Staffan

Re: Fast Change

jonathandienst — Fri, 10 Jan 2014 10:51:41 GMT

=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

Re: Fast Change

Fri, 10 Jan 2014 11:44:35 GMT

Its not working in my case.

Re: Fast Change

Fri, 10 Jan 2014 11:44:58 GMT

I tried this but its the same.

Re: Fast Change

Fri, 10 Jan 2014 11:48:33 GMT

Its still not working.

Re: Fast Change

stabben23 — Fri, 10 Jan 2014 11:55:05 GMT

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

//Staffan

Re: Fast Change

Fri, 10 Jan 2014 12:16:13 GMT

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

Re: Fast Change

jagan — Fri, 10 Jan 2014 12:22:44 GMT

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.

Re: Fast Change

Fri, 10 Jan 2014 12:27:31 GMT

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

That is fine i dont want icon to be displayed

Re: Fast Change

Gysbert_Wassenaar — Fri, 10 Jan 2014 14:34:06 GMT

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

Re: Fast Change

Mon, 13 Jan 2014 05:20:46 GMT

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.