Help required in evaluating count () in the below expression

sandeepprasad_j — Thu, 04 Apr 2013 15:39:30 GMT

Hi Experts ,

Please find the following expression that have been used to calculate the no. of rows containing specific field values :

count({<[From Task]={'PublishingHolding' , 'ReviewAndProofHolding' , 'EscalatedPDS'}>}[To Task]='Escalations')

The expected output should be the number of rows where the field value in [From Task] column is 'PublishingHolding' or 'ReviewAndProofHolding' or 'EscalatedPDS' and the value in [To Task] column is 'Escalations'. Kindly let me know if the above expression is correct, suggest any changes if required.

Thanks a Heap.

Re: Help required in evaluating count () in the below expression

kaushiknsolanki — Fri, 05 Apr 2013 07:30:43 GMT

Hi,

Try this expression.

count({<[From Task]={'PublishingHolding' , 'ReviewAndProofHolding' , 'EscalatedPDS'},[To Task]={'Escalations'}>}1)

Regards,

Kaushik Solanki

topic Re: Help required in evaluating count () in the below expression in QlikView

Help required in evaluating count () in the below expression

Re: Help required in evaluating count () in the below expression