topic Re: Help with an Expression and Input Box in QlikView

Help with an Expression and Input Box

syed1 — Tue, 12 Mar 2019 00:29:42 GMT

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

Re: Help with an Expression and Input Box

jonathandienst — Tue, 12 Mar 2019 05:07:30 GMT

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

Re: Help with an Expression and Input Box

Sue_Macaluso — Tue, 12 Mar 2019 16:11:39 GMT

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.

Re: Help with an Expression and Input Box

Surya — Wed, 13 Mar 2019 06:45:32 GMT

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

like..

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