topic Set Analysis Help in QlikView

Set Analysis Help

Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Set Analysis Help

sunny_talwar — Mon, 12 Sep 2016 17:00:07 GMT

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)