set analysis help

raz-datamind — Mon, 18 Mar 2013 11:22:23 GMT

Hi,

I'm triyng to create a set analysis to disregard selections in the model, except selections in 3 fields, the set analysis also needs to apply only to part of the records based on sum(qnty)>=1.

My expression is as follows:

count({1< attribute_field= {1}, Store=$::Store, Date= {'>=$(=date(vDate1) <=$(=date(vDate2))'}, trans= {"=sum(qnty)>=1"} >} distinct trns)

I want to only count trans with qnty>=1, when the date is between the variables, attribute is 1 and to regard the current store selected.

Problem is, i get 0, which i know is wrong.

When applying the set analysis with the attribute, store and either date or qnty conditions i get results, but when i put both date and qnty conditions it fails.

Anyone has any idea to what the problem is?

Thanks.

topic set analysis help in QlikView

set analysis help