Set Analysis sum based on sum and if condition

New-Qlik — Thu, 01 Aug 2019 09:54:21 GMT

I want to write below expression

if(Days <= '10',

sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 and sales 2)/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)

sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 )/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)

howto write sum of sales1 and sales2 in one sum set analysis expression

Re: Set Analysis sum based on sum and if condition

lironbaram — Thu, 01 Aug 2019 10:06:40 GMT

try like this

if(Days <= '10',

(sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 )+sum( {$<[FY]={"=$(vCurrentFY)"}>} sales 2))/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)

sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 )/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)

if both fields sales 1 and sales 2 are in the same table than you can also use

if(Days <= '10',

(sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1+ sales 2))/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)

sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 )/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)