Remove Default selected values

[#1]

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

[Chanty4u]

chk dis

How can I clear the default selections in Qlik Sense

[#3]

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.

[#4]

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

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

[Anonymous]

Use GetSelectedCount function. You can achieve your desired output

[#6]

I am using below expression,

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

how can i use both GetSelectedCount and If statement?

[#7 · Accepted solution]

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

[Chanty4u]

add dis to ur exp before

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

[Anonymous]

Hi,

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

Hope it helps!!