Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prashantsanchet
Contributor

Sales for null Customer based on following condition

Hi Team,

I am having following condition

  • One Business Date which is always selected:
  • For that Business date, we are adding

     ITDTotal Sales =  Last Year Last date ITDSales value + YTDSales value for Current Business date 

  • Customer as Dimension
  • measure  as following

num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales] +

    

sum([YTDSales),'#,##0')


  • Enable the null values for Bar Chart

I want to show the

  • Total ITDSales in KPI (Including null)
  • How we can calculate TotalITDSales for null  Customer for above measure





4 Replies
OmarBenSalem
Esteemed Contributor

Re: Sales for null Customer based on following condition

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/

prashantsanchet
Contributor

Re: Sales for null  Customer based on following condition

Hi ,

Thanks for your reply . But still i need to get this.

  • I am using this expression in  bar chart and i am exporting the data in excel.
  • i want to show the null value in chart but i cant make changes in load script
  • Total ITDSales in KPI (Including null) should be equal to exported total
  • How we can calculate TotalITDSales for null  Customer for below measure

num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales] +

   

sum([YTDSales),'#,##0')

OmarBenSalem
Esteemed Contributor

Re: Sales for null  Customer based on following condition

can u try :

sum({<Customer ={"=isnull(Customer )"}>}Value)

?

prashantsanchet
Contributor

Re: Sales for null Customer based on following condition

This is not working

Community Browser