Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

calculatin rate of sale

if i select last year, then it shoould be retail quanity /52(number of weeks in a year). if i select current year from period filter, suppose current month is jan then calculation be like retail quantity/4(number of weeks in jan month) if current month is aug then calculation should be retail quanity/36(number weeks till august)  and if the current month is oct then calculation be like retail quantity/40(number of weeks till oct) .