Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

conditional enabling of line in line chart as per requirement

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

1 Solution

Accepted Solutions
Kushal_Chawda

Please see the attached

View solution in original post

14 Replies
Not applicable

Hey, you need to link two tables to see the selections working. If you see in table viewer there is no common field in two tables.

Not applicable

Hello Deepak,

If you want desire report use condition like "SubStringCount(Concat(Region, '|'), 'US') or (GetSelectedCount(Region)=0 or GetSelectedCount(Region)>3 or GetFieldSelections(Region)='All')"  in each expression.

Please find attached file for more details.

Thanks,

Uday.

deepakqlikview_123
Specialist
Specialist
Author

Hi all,

one more thing need to add we are using inline table region just for enabling line dynamically, so it is separated

Thanks

Kushal_Chawda

Please see the attached.

deepakqlikview_123
Specialist
Specialist
Author

Hi kush,

thanks for reply but below is requirement when user can select all in region all lines should be display.

but whenever user can select any region except all it user can select up to maximum 3 regions when user trying to select 4th region it will clear all of the selection and show US.

thanks

Kushal_Chawda

Please see the attached

qlikviewwizard
Master II
Master II

Hi Kush141087

Good solution.Thank you.

Kushal_Chawda

qlikviewwizard  I glad that it helps.

deepakqlikview_123
Specialist
Specialist
Author

Hi Kush,

When i am selecting West region it is showing MidWest Region and SouthWest Region's selection also as we are comparing strings can u please suggest how to handle this.



thanks,

Deepak