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: 
Not applicable

Set Analysis Help

Hello all,

Need your help in removing the following IF condition, via set analysis.

IF(SUM({<BSIK_BUCKET,AR_BUCKET_FINAL,link_Date,TXN_TYPE = {'BSID'}>}Amount)>='500000',

SUM({<  AR_BUCKET_FINAL_NEW = {'NOT DUE'}, BSIK_BUCKET,AR_BUCKET_FINAL,link_Date,TXN_TYPE = {'BSID'}>}Amount)/vLacs)

1 Reply
sunny_talwar

Is this used in a table with just one dimension? or are there multiple dimensions in the table? If you have just one, you can try this:

Sum({<AR_BUCKET_FINAL_NEW = {'NOT DUE'}, BSIK_BUCKET,AR_BUCKET_FINAL, link_Date, TXN_TYPE = {'BSID'}, DimensionName = {"=Sum({<BSIK_BUCKET,AR_BUCKET_FINAL,link_Date,TXN_TYPE = {'BSID'}>}Amount)>='500000' "}>}Amount)/vLacs)