Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Highlighted
Not applicable

Re: Remove Default selected values

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

8 Replies
sureshqv
Esteemed Contributor III

Re: Remove Default selected values

Not applicable

Re: Remove Default selected values

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

Re: Remove Default selected values

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

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

qlikviewnovice
Valued Contributor II

Re: Remove Default selected values

Use GetSelectedCount function. You can achieve your desired output

Not applicable

Re: Remove Default selected values

I am using below expression,

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

how can i use both GetSelectedCount and If statement?

Highlighted
Not applicable

Re: Remove Default selected values

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

sureshqv
Esteemed Contributor III

Re: Remove Default selected values

add dis to ur exp before

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

qlikviewnovice
Valued Contributor II

Re: Remove Default selected values

Hi,

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

Hope it helps!!