topic Re: Set analysis help in QlikView

Set analysis help

Mon, 31 Aug 2015 02:12:59 GMT

Am I missing anything in the below set analaysis ?

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

Thank you.

Re: Set analysis help

svenkita — Mon, 31 Aug 2015 03:03:05 GMT

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

Re: Set analysis help

jagan — Mon, 31 Aug 2015 03:11:18 GMT

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.

Re: Set analysis help

Anonymous — Mon, 31 Aug 2015 03:29:34 GMT

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.

Re: Set analysis help

qlikviewwizard — Mon, 31 Aug 2015 08:08:28 GMT

Hi Stacey,

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