topic Re: Problem in Expression !! in QlikView

Problem in Expression !!

nikhilgarg — Mon, 29 Sep 2014 10:33:51 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

if([Maturity Year]<=2014,

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

Thanks

Re: Problem in Expression !!

sspe — Mon, 29 Sep 2014 11:05:41 GMT

Hi,

Have you tried to troubleshoot it "step-wise"? I'd suggest that you start with e.g. just the first COUNT.... to see if that works. If that shows you some numbers, then you can try adding the IF statement and so on. Then you'll find which part of the statement that fails.

/Steen

Re: Problem in Expression !!

nikhilgarg — Mon, 29 Sep 2014 11:08:18 GMT

HEy instead of above script i used this way:

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

But i want to comapre for Maturity Year <=2014 But it gives me error when i use <=.

WHat to do ??

Re: Problem in Expression !!

jyothish8807 — Mon, 29 Sep 2014 11:14:45 GMT

So write:

[Maturity]={"<=2014"}

REgards

Re: Problem in Expression !!

Mon, 29 Sep 2014 11:15:06 GMT

Try this,

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

Re: Problem in Expression !!

PrashantSangle — Mon, 29 Sep 2014 11:15:26 GMT

Hi,

If this expression works for you

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

then try for <= in set analysis

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

Regards