topic Re: Expression Error !! in QlikView

Expression Error !!

nikhilgarg — Mon, 29 Sep 2014 11:06:29 GMT

Hey,

I am having a dummy database where i am calculating insurance claimed by female.

I am using following expression but no data is being displayed. Please help

Count({<Product = , [Customer Gender] = {"Female"} , [Maturity Year] = {2014}>}[Customer Name])/Count({<[Customer Gender]={"Female"}>}[Customer Name])

And also i want to compare with MAturity Year <=2014 but when i used [Maturity Year] <= {2014} , it gives me error.

Please tell what to do ??

Thanks

Re: Expression Error !!

senpradip007 — Mon, 29 Sep 2014 11:15:59 GMT

Try like

Count({<Product = , [Customer Gender] = {'Female'} , [Maturity Year] = {2014}>} [Customer Name])

Count({<[Customer Gender]={'Female'}>} [Customer Name])

Re: Expression Error !!

Anonymous — Mon, 29 Sep 2014 11:25:36 GMT

Count({<Product = , [Customer Gender] = {'Female'} , [Maturity Year] <= {2014}>} [Customer Name])

Count({<[Customer Gender]={'Female'}>} [Customer Name])

Re: Expression Error !!

maxgro — Mon, 29 Sep 2014 11:32:52 GMT

for maturity add to set analysis

[Maturity Year]={"<=2014"}