conditional enabling of line in line chart as per requirement

[deepakqlikview_123]

Hi All,

PFA.

Below is scenario.

I have different regions in a list box in line chart different line wrt to particular region.

when ever i can select All it can show all lines for all regions.

but when ever i can select different regions it can show line wrt that particular region.

moreover line whatever i am selection except 'All Regions' should be restricted up to 3 maximum regions.

suppose i can select Midwest, northwest and west region it should show 3 lines wrt that and when selection of region exceeds 3 region selection it should go to its default region selection that is' All' region.

Please suggest

[sunny_talwar]

Working with Personal Edition of QlikView, so can't really see what solution you are working with right now. Can you share the expression you are currently using and may be I can look at it as well . Only if it is not a hassle

Best,

Sunny

[deepakqlikview_123]

Hi sunny,

below is the expression that we are using

=if(WildMatch(GetFieldSelections(Region),'*MidWest*','*All*') or GetSelectedCount(Region)<=0, 1,0)

thanks

[sunny_talwar]

This doesn't seem like one for the West? Is this for the MidWest and you seem to fix West right?

=if(WildMatch(GetFieldSelections(Region),'*West*','*All*') or GetSelectedCount(Region)<=0, 1,0)

May be try this:

If(SubStringCount('|' & Concat(DISTINCT Region, '|') & '|', '|West|') = 1, 1, 0)

If(SubStringCount('|' & Concat(DISTINCT Region, '|') & '|', '|West|') = 1 or SubStringCount('|' & Concat(DISTINCT Region, '|') & '|', '|All|') = 1, 1, 0)

[sunny_talwar]

Please find the difference between the two expressions in the attached qvw.

HTH

Best,

Sunny

[Kushal_Chawda · Accepted solution]

Please see the attached