Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

renjithpl
Valued Contributor

Create a field/selection based on expression

Hi All,

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

Email ID of Notice RecipientMatters Involved0 - No ResponseCompliance Rate
22
abc.yahoo.com11100.00%
xyz.yahoo.com100.00%
pqr.yahoo.com11100.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 RecipientMatters Involved0 - No ResponseCompliance Rate
22
abc.yahoo.com11100.00%
pqr.yahoo.com11100.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

1 Solution

Accepted Solutions
christophebrault
Valued Contributor

Re: Create a field/selection based on expression

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.

3 Replies
christophebrault
Valued Contributor

Re: Create a field/selection based on expression

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
Valued Contributor

Re: Create a field/selection based on expression

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

Highlighted
renjithpl
Valued Contributor

Re: Create a field/selection based on expression

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