Help with an Expression and Input Box

[syed1]

Hello

I have two requirements:

1. I am writing an expression that does gives a Count of  Total Customers per Country

I am currently using the expression

=COUNT(TOTAL<Country> DISTINCT [Customer])

Is this correct? Or is there an alternate way?

2. I have a dimension Customer and I want to create an input box for it so that I can enter any of the field values in that field

For example:

If I enter a value A in the input box then it should show me all the info pertaining to Customer A in the rest of my sheets

Regards

Syed

[jonathandienst]

1.  If you are in a table where Country is a dimension, then that should work.

2. Create list box(or filter pane) with Customer as the field. 

>>If I enter select a value A in the input list box then it should show me all the info pertaining to Customer A in the rest of my sheets - that's normal out the box behaviour for Qlik

[Sue_Macaluso]

This is referring to QlikView or Sense? I would like to get this into the correct product forum. This one is for general discussions on the community platform.

[Surya]

Here we need to create a variable for using inputox...the same variable we are using in expression also

like..

count({<customername = {'$(variablename)'}>}country)