Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Expression Error !!

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

for maturity add to set analysis

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

View solution in original post

3 Replies
senpradip007
Specialist III
Specialist III

Try like

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

/

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

Anonymous
Not applicable

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

/

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

maxgro
MVP
MVP

for maturity add to set analysis

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