Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
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%')