Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all, I am new to Qlik and need help
I need to do a calculation sum(Sales)/sum(Profit).
I am calculating Num and denominator separately, and I have to calculate ony for certain category types..
For Numerator, I created Measure1 : Sum{<Category= {'ABC','DEF'}>} Sales)
For Denominator, I created Measure2: Need to first calculate the average : Avg({<Category= {'ABC','DEF'}>} Profit)
How do I calculate sum of Measure2? using set analysis?
@Aag If I understood correctly are you looking for measure 2 this ?
sum(aggr(Avg({<Category= {'ABC','DEF'}>} Profit),Dimension(s)))
Dimension(s)-> Dimension1,Dimension2... => dimensions you use in the chart
@Aag If I understood correctly are you looking for measure 2 this ?
sum(aggr(Avg({<Category= {'ABC','DEF'}>} Profit),Dimension(s)))
Dimension(s)-> Dimension1,Dimension2... => dimensions you use in the chart
Awesome! This calculation did the trick!! Thanks a ton @Taoufiq_Zarra