topic Static logic in QlikView

Static logic

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How to make the below logic as static..like it wont reflect as per any filter selection.

num(((sum({$<AuditDate={'>=$(VSSSCurrMonthStart)<=$(vSSSYesterday)'}>}TOTAL PostedSales)

sum({$<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales))

sum({$<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales)),'#.##%')

Thanks..

sunny_talwar — Fri, 27 May 2016 09:55:11 GMT

May be this:

Num(((Sum({1<AuditDate={'>=$(VSSSCurrMonthStart)<=$(vSSSYesterday)'}>}TOTAL PostedSales)

Sum({1<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales))

Sum({1<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales)),'#.##%')

You may also need to make the same modification within your variables if those are expressions too.

UPDATE: Would be able to share some details about those 6 variables?

PrashantSangle — Fri, 27 May 2016 09:59:54 GMT

write 1 instead of $ in set analysis.

try with nullify user possible selections

Regards

nareshthavidishetty — Fri, 27 May 2016 10:05:56 GMT

Thanks..it working fine