Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please see the attached
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.
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.
Hi all,
one more thing need to add we are using inline table region just for enabling line dynamically, so it is separated
Thanks
Please see the attached.
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
Please see the attached
Hi Kush141087
Good solution.Thank you.
qlikviewwizard I glad that it helps.
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