Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator III
Creator III

Set Analysis sum based on sum and if condition

 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

 

1 Reply
lironbaram
Partner - Master III
Partner - Master III

hi 

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)