Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

syed1
New 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

Tags (2)
3 Replies
MVP
MVP

Re: Help with an Expression and Input Box

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
Community Manager
Community Manager

Re: Help with an Expression and Input Box

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
Highlighted
Surya
New Contributor III

Re: Help with an Expression and Input Box

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

like..

 

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