Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove Default selected values

Hi all,

I have created a sheet with table and filter pane, when i select the value in filter pane the counts in the table is filtering properly,

When it is not selected anything in the filter pane, it's displaying all the values from the db, how can i make it zero till selection is made in the filter pane.

Regards,

Pramod

1 Solution

Accepted Solutions
Not applicable
Author

IF(GetSelectedCount([Client])>0,Count({$<DateTimeType = {'signed_time'},user_signed={1}>}invitation_id),0)

View solution in original post

8 Replies
Not applicable
Author

Thanks for the reply,

My issue is for example i have a measure: count(invitation_id). when i select any client from filter pane, it will display the count of that client, if any client is not selected it will display the count of all client. Instead i need to display zero when no selection is made.

Not applicable
Author

use GetSelectedCount ‒ Qlik Sense ‌to find out if anything is selected.

An IF statement around that will give you what you want.

Anonymous
Not applicable
Author

Use GetSelectedCount function. You can achieve your desired output

Not applicable
Author

I am using below expression,

Count({$<DateTimeType = {'signed_time'},user_signed={1}>}invitation_id)

how can i use both GetSelectedCount and If statement?

Not applicable
Author

IF(GetSelectedCount([Client])>0,Count({$<DateTimeType = {'signed_time'},user_signed={1}>}invitation_id),0)

Chanty4u
MVP
MVP

add dis to ur exp before

if(GetSelectedCount(Client)>0,urexp,0)

Anonymous
Not applicable
Author

Hi,

=If(GetSelectedCount(Replaceyourfieldname)>0,Count({$<DateTimeType = {'signed_time'},user_signed={1}>}invitation_id),0)

Hope it helps!!