topic Create a field/selection based on expression in QlikView

Create a field/selection based on expression

renjithpl — Wed, 13 Jun 2012 14:12:59 GMT

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

Re: Create a field/selection based on expression

christophebrault — Wed, 13 Jun 2012 14:36:48 GMT

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.

Re: Create a field/selection based on expression

renjithpl — Thu, 14 Jun 2012 05:49:44 GMT

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

Re: Create a field/selection based on expression

renjithpl — Thu, 14 Jun 2012 05:55:20 GMT

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%')