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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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)