topic Re: Help with condotions? in QlikView

Help with condotions?

Wed, 20 May 2015 17:47:57 GMT

Hi,

I have a requirement where an text box should appear up on different selections in a filed. For exaple

Sales:

load * Inline

[Name,Sales

Bob,100

John,112

Sam,113,

Richard,200];

a text box should appear only up on selection of Bob and John and other should appear only when we select John and Sam etc for the different combinations.

I used =SubStringCount(concat(Name,'|'),'Bob|John') but its working only for one combination.

Please post your ideas on this.

Thanks

Re: Help with condotions?

swuehl — Wed, 20 May 2015 18:01:03 GMT

Maybe like

=concat(Name,'|') = 'Bob|John'

Re: Help with condotions?

sunny_talwar — Wed, 20 May 2015 18:01:06 GMT

Try with this as your condition on Layout tab:

=SubStringCount(GetFieldSelections(Name), 'Bob') = 1 and

SubStringCount(GetFieldSelections(Name), 'John') = 1

Re: Help with condotions?

Wed, 20 May 2015 18:55:50 GMT

Thanks for the reply.

But for my original requirement when user sleet NA and EMEA, a text box should appear across the map covering both NA and EMEA. and when user select EMEA and APAC a text box should cover both regions.

I uses your function but its not working. Can you please look in to attached QVW?

Re: Help with condotions?

sunny_talwar — Wed, 20 May 2015 19:04:09 GMT

This condition should work for you:

=Concat(DISTINCT Region, '|') = 'EMEA|NAM'

Re: Help with condotions?

Wed, 20 May 2015 19:13:22 GMT

It works

Thank you