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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
prahladind9
Partner - Contributor III
Partner - Contributor III

How to use 'and' 'or' '>'(greater than) in Set Analysis in a expression?

COUNT(if(CATEGORY = 'LIABILITY' AND DATESTART>=DATEPREVFINYEARSTART, CUSTOMERACCOUNTID))

I want to convert this expression into set analysis exp.

like count({$<CATEGORY = {'LIABILITY'}>}CUSTOMERACCOUNTID)

I don't know how to complete the expression.

Please help me out.

Thanks.

13 Replies
prahladind9
Partner - Contributor III
Partner - Contributor III
Author

Thank you.

Small thing still remaining 

IF(MODULE = 'OD', AMTSANCTIONEDLCY, IF(MODULE = 'LOANS', AMTCRTURNOVERTODAYLCY))

In Set Analysis Format...

sunny_talwar

Is this an expression or dimension?

prahladind9
Partner - Contributor III
Partner - Contributor III
Author

Expression

SUM(IF (AMTDEBITBALLCY > 0 AND (AMTTOTALODUTILIZEDLCY > AMTTOTALODLIMITLCY) and (APPLICATIONDATE =  DATEFIRSTOVERDRAWN )

, AMTDEBITBALLCY - AMTTOTALODLIMITLCY))

somacdc
Contributor III
Contributor III

I want to following data

FOLIO_NUMBER_UHRTOTAL_NO_OF_UNIT_OF_UH
1166633.7933
20.3334
30.12
4133333.3333
52500

 

After applying following condition Folio number 2 and 3 disappear.

ApplyMap('UH_REGISTER_MAPPING', FUND_ID &'-'& FOLIO_NUMBER, 0) >> 0