Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have no experience of writing expressions in click view and could use a bit of help please.
I have data loaded with one field called admitmethod (possible values are '1' or '2'). I have a pivot table in which I want to count another field called CRN which
is a unique identifier for individuals, but I only want to count those with an admitmewthod of '2'.
How would I write the expression for this?
I have tried a few things but don't really understand the syntax. Thanks for any pointers....
If the CRN and admitmethod are in the same table, it may be worth doing something like this in the load of that table:
if(admitmethod='2',CRN) as "CRN with Admit Method 2" // or whatever name makes sense
To simplify (and probably slightly speed up) your expression to this:
count("CRN with Admit Method 2")
Count({<admitmethod = {'2'}>} CRN)
If the CRN and admitmethod are in the same table, it may be worth doing something like this in the load of that table:
if(admitmethod='2',CRN) as "CRN with Admit Method 2" // or whatever name makes sense
To simplify (and probably slightly speed up) your expression to this:
count("CRN with Admit Method 2")
Thanks a lot John,
That is a very useful technique you highlight and works well for my purposes.
Dave.