Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
PP_12
Contributor III
Contributor III

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

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!

1 Solution

Accepted Solutions
PP_12
Contributor III
Contributor III
Author

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...

View solution in original post

5 Replies
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

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
PP_12
Contributor III
Contributor III
Author

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

 

 

 

 

 

 

 

 

 

 

 

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
PP_12
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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