Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
raz-datamind
Partner - Contributor
Partner - Contributor

set analysis help

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.

0 Replies