Discussion Board for collaboration on QlikView Scripting.
Could you please confirm whether the below given expression is accurate
Month Sales, Planned
Jun 100 100
Jul 150 100
Aug 0 200
Based on above sample data, i would like to calculate cumulative sales for 3 months
Sum all sales but if sales is equal to zero , then planned value should be aggregated
Thus , total value for three months should 100+150+200 = 450
Go to Solution.
I guess you're looking for IsNull(Sales) rather than Sales=0:
hope this helps
I think the easiest thing would be to create a new field that contains or Planned Sales, Sales according to either = 0 or not.
Then this calculated field new
if(sum(Sales=0), sum(Planned), sum(Sales))
load * Inline
LOAD * ,
if(Sales=0,Planned,Sales) as Sales_planned
DROP Table Sales;
it doesn not work
Please post sample APP/data
Please find QVW and data source
It works as expected.
What are you trying to achieve here.
Can you post your required output .