How to write expression for using Getselectedcount to only show table based on selection on filter pane

[PP_12]

Hello, 

I'm new to qlik and just wanted to know if the below expression is okay to use. Or is there are better way to use set analysis for this?
I am wanting to only show a table if a selection has been made using the filter pane ( 5 dimensions). I had a read and found that you need to use add-ons > data handling > calculation condition but only saw examples of 2-3 dimensions used. 

=GetSelectedCount([_id])>0 or GetSelectedCount([full_address])>0 or GetSelectedCount([local_authority])>0 or GetSelectedCount([full_address])>0 or GetSelectedCount([road_name])>0

Any suggestions are greatly appreciated

Thank you!

[vikasmahajan]

Hi,

you can use get selected count with if condition like following 

if ( =GetSelectedCount([_id])>0 or GetSelectedCount([full_address])>0 , < Your Expression> )

Hope this helps you

Vikas

[PP_12]

Hi Vikas,

Thank you for your response. Just a question how would I add 5 dimensions into the if statement? Could I get an example please.

if ( =GetSelectedCount([_id])>0 or GetSelectedCount([full_address])>0 , < Your Expression> )

Thank you so much 

Penny

[vikasmahajan]

Yes you can use if statements

Thanks

Vikas

[PP_12 · Accepted solution]

Thanks, I think I might have found another solution and it works if( Len(GetCurrentSelections())>0, 1, 0) 
https://community.qlik.com/t5/New-to-Qlik-Sense/one-GetSelectedCount-statement-for-all-dimensions/td...

[PP_12]

Thanks, I found another solution that does what I want. Got it from here https://community.qlik.com/t5/New-to-Qlik-Sense/one-GetSelectedCount-statement-for-all-dimensions/m-...

if( Len(GetCurrentSelections())>0, 1, 0)    and it works