Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Expression

Hi All, 

I am trying to get the data based on row to row match comparing to fields , but along with set analysis 

the expression don show any error but this even doesn't give any out put also , Can any one please help me in correcting my expression 

=if(Product=SubProd,
count(Distinct{<STATUS_NAME-={'Delivered'},
SEVERITY={'1 - Critical','2 - High','3 - Medium' }>} if(CREATE_DATE>IntDate , ID)))

 

Thanks

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Your issue can be casued by many things, it's hard to pinpoint whitout more details.

However, my first thing to check would be the result of Product=SubProd. If you have more than one Product and SubProduct per calculation you will run into issues.

It this is the issue then you might  be able to do a workaround using this expression.

=count(Distinct{<STATUS_NAME-={'Delivered'}, SEVERITY={'1 - Critical','2 - High','3 - Medium' }>} if((CREATE_DATE>IntDate) AND (Product=SubProd) , ID))

 

 

View solution in original post

3 Replies
MarcoWedel

can you please post some sample values and your expected result as well?

thanks

Vegar
MVP
MVP

Your issue can be casued by many things, it's hard to pinpoint whitout more details.

However, my first thing to check would be the result of Product=SubProd. If you have more than one Product and SubProduct per calculation you will run into issues.

It this is the issue then you might  be able to do a workaround using this expression.

=count(Distinct{<STATUS_NAME-={'Delivered'}, SEVERITY={'1 - Critical','2 - High','3 - Medium' }>} if((CREATE_DATE>IntDate) AND (Product=SubProd) , ID))

 

 

smilingjohn
Specialist
Specialist
Author

Thanks a lot Vegar you rock man ✌️