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: 
syed1
Contributor
Contributor

Help with an Expression and Input Box

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

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Sue_Macaluso
Community Manager
Community Manager

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.
Sue Macaluso
Surya
Creator II
Creator II

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

like..

 

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