Discussion Board for collaboration related to QlikView App Development.
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.
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.
one more thing need to add we are using inline table region just for enabling line dynamically, so it is separated
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.
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.