Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am having following condition
ITDTotal Sales = Last Year Last date ITDSales value + YTDSales value for Current Business date
num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales] +
sum([YTDSales),'#,##0')
I want to show the
In ur script:
SET NullValue=”N/A”;
NullAsValue Customer ;
That way, the null customers will be interpreted in the calculations
Pleasee refer to :
http://www.johndaniel.com/index.php/when-values-arent-values-null-handling-in-qlik/
Hi ,
Thanks for your reply . But still i need to get this.
num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales] +
sum([YTDSales),'#,##0')
can u try :
sum({<Customer ={"=isnull(Customer )"}>}Value)
?
This is not working