topic interpreting an expression...help please in QlikView

interpreting an expression...help please

Fri, 17 Feb 2012 14:11:46 GMT

Hello,

I have to count a field and I have a small problem.

How this expression can be interpreted into expression tab inside a pivot table:

if(policy.POLICY_STATE>=0 and policy.POLICY_STATE<=30 and ... ,

count(POLICY_ID))

I would like to count only POLICY_ID's that are in 'tab1' table.

Where should I put this condition?

It should be something like count(POLICY_ID from table 'tab1')

Thank you,

Silviu.

Fri, 17 Feb 2012 14:24:12 GMT

or count ONLY the POLICY_ID's that are in table 'tab1'...how this can be inserted into a expression ?

Anonymous — Fri, 17 Feb 2012 14:29:29 GMT

You just try to count the Policy_id values from the table which are all in the tab1 edit script

Regards

Ashok

Fri, 17 Feb 2012 14:33:50 GMT

I am counting only the POLICY_ID's that meet the conditions and only those that are in my table 'tab1'.

How can this be possible, because I'm sure that is a simple function...

marcos — Fri, 17 Feb 2012 20:45:35 GMT

Hi,

try the expresion in this way:

count( if(policy.POLICY_STATE>=0 and policy.POLICY_STATE<=30 and ... , POLICY_ID))

the problem is that the condition must be inside the count function