Set analysis help

[#1]

Am I missing anything in the below set analaysis ?

Count({<[service(s) awarded]={'PjM'}>}[New Prospect, Renewal or Expansion])

Thank you.

[svenkita]

looks fine i have added a test qvw file with the same expression

[jagan]

Hi,

If you attach sample file then it would be easier to trace the issue, the expression looks ok.  Check do you have data for this condition [service(s) awarded]={'PjM'}.

Also note that Qlikview is case sensitive PjM and PJM is different.

Regards,

jagan.

[Anonymous]

Just to be sure, delete every thing and write your syntax again. sometimes It does not take the expn if there are white spaces. Also, were you trying to distinctly count [New Prospect, Renewal or Expansion], this field? In that case it would be   Count({<[service(s) awarded]={'PjM'}>} Distinct [New Prospect, Renewal or Expansion]) Also, as Jagan suggested it might be because PJM might be the correct field value.

[qlikviewwizard]

Hi Stacey,

Did you able to get the solution? If not, please attach the sample file with the data. Thank you.