Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: conditional enabling of line in line chart as per requirement

Please see the attached

View solution in original post

14 Replies
Highlighted
Not applicable

Re: conditional enabling of line in line chart as per requirement

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.

Highlighted
Not applicable

Re: conditional enabling of line in line chart as per requirement

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.

Highlighted
Specialist
Specialist

Re: conditional enabling of line in line chart as per requirement

Hi all,

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

Thanks

Highlighted

Re: conditional enabling of line in line chart as per requirement

Please see the attached.

Highlighted
Specialist
Specialist

Re: conditional enabling of line in line chart as per requirement

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

Highlighted

Re: conditional enabling of line in line chart as per requirement

Please see the attached

Highlighted
Master II
Master II

Re: conditional enabling of line in line chart as per requirement

Hi Kush141087

Good solution.Thank you.

Highlighted

Re: conditional enabling of line in line chart as per requirement

qlikviewwizard  I glad that it helps.

Highlighted
Specialist
Specialist

Re: conditional enabling of line in line chart as per requirement

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