Create a field/selection based on expression

[renjithpl]

Hi All,

I have a table which is extracted from qlikview to excel export like below:

Email ID of Notice Recipient	Matters Involved	0 - No Response	Compliance Rate
	2	2
abc.yahoo.com	1	1	100.00%
xyz.yahoo.com	1	0	0.00%
pqr.yahoo.com	1	1	100.00%

My coding for compliance rate is  =count( {$<Type = {[3 - Response with full compliance]}>} Type ) / Count(distinct [Matter ID])

Now my requirement is, i need a listbox like this in my application:

Levels

0.00%

100.00%

When i select 100.00% i should get a my result like this:

Email ID of Notice Recipient	Matters Involved	0 - No Response	Compliance Rate
	2	2
abc.yahoo.com	1	1	100.00%
pqr.yahoo.com	1	1	100.00%

I saw one example in one of qlikive sample application (online Sales) - here they created "Age" as dimension.

Please reply back if you need more clarification.

thanks

Ranjith

[christophebrault · Accepted solution]

Hi,

In the app you saw, they use class() function as a dimension. In your case with your expression, you can try this :

aggr(count( {$<Type = {[3 - Response with full compliance]}>} Type ) / Count(distinct [Matter ID]),[Email ID of Notice Recipient])

Use this expression as an expression in list box.

[renjithpl]

HI Chrisopher,

Is there a way to give something like, less than 50%, greater than 50%, so when i select less than 50% it gives all the values below 50% and above should give all values more than 50%.

THanks

[renjithpl]

I tried something like below, it worked.

if(aggr(count( {$<Type = {[3 - Response with full compliance]}>} Type ) / Count(distinct [Matter ID]),[Email ID of Notice Recipient]) >50/100, 'above 50%', 'below 50%')