Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaysingh285
Contributor III
Contributor III

Show Quarterly % in Expression

Hi Members,

I am not able to group the expression in percentage on the basis of quarter.

I have the scenario given below:-

 

Quarter(as Dimension)  Sum(expression1)+Sum(expression2)
$313,962.93
Q1$36,260.47
Q1$24,627.60
Q1$26,368.20
Q2$27,909.51
Q2$26,747.78
Q2$27,576.78
Q3$25,242.10
Q3$24,848.75
Q3$24,820.91
Q4$23,270.59
Q4$20,847.45
Q4$25,442.78

i am having Quarter as Dimension and other as sum of two expression. so the sum ( exp1 and exp2) which total is bifurcate to different quarters which is good.

But my question is , i need the percentage of  each Quarter. like percentage for Q1,Q2,Q3,Q4?

Can any body help me out from this?

1 Solution

Accepted Solutions
sunny_talwar

And this isn't working?

=((sum({< [Month End]={'$(vVariable)'},nDateMonth={'<$(vStartMonth)'}>} [Budget])  /  $(vDividend)) +

(sum({< [Month End]={'$(vVariable)'},nDateMonth={'>=$(vStartMonth)'}>} [Budget])  /  $(vDividend)))/

((sum(TOTAL {< [Month End]={'$(vVariable)'},nDateMonth={'<$(vStartMonth)'}>} [Budget])  /  $(vDividend)) +

(sum(TOTAL {< [Month End]={'$(vVariable)'},nDateMonth={'>=$(vStartMonth)'}>} [Budget])  /  $(vDividend)))

View solution in original post

10 Replies
sunny_talwar

What is the expected output for the sample data provided?

ajaysingh285
Contributor III
Contributor III
Author

Sum(Q1$value)/sum(Q1$ value+Q2$ value+Q3$ value+Q4$ value)  *100 respectively for  Q2 ,Q3,Q4 which is in percentage form

sunny_talwar

Something like this

(Sum(expression1)+Sum(expression2))/(Sum(TOTAL expression1)+Sum(TOTAL expression2))

ajaysingh285
Contributor III
Contributor III
Author

i have tried sum(total) but it shows blank. Do u have any alternate way

sunny_talwar

May be if you can share a sample, I might be able to look into it. Difficult to guide without knowing what all you have

ajaysingh285
Contributor III
Contributor III
Author

These are my two expressions which gives the sum of $ value column. How can we do the Quarter percentage in this

=(sum({< [Month End]={'$(vVariable)'},nDateMonth={'<$(vStartMonth)'}>} [Budget])  /  $(vDividend)) +

(sum({< [Month End]={'$(vVariable)'},nDateMonth={'>=$(vStartMonth)'}>} [Budget])  /  $(vDividend))

sunny_talwar

Don't know.... ... expressions alone don't really help understand what else might have... image or sample might help

ajaysingh285
Contributor III
Contributor III
Author

1.PNG

In this i need % values Quarterly with the help of using that expression.

for ex:-

Q1$ values / (Q1 $ value+Q2 $ value+Q3 $ value+Q4 $ value)

like wise for Q2,Q3,Q4 as well with help of expression.

Quarter is dimension here and in $ values is used as expression .

sunny_talwar

And this isn't working?

=((sum({< [Month End]={'$(vVariable)'},nDateMonth={'<$(vStartMonth)'}>} [Budget])  /  $(vDividend)) +

(sum({< [Month End]={'$(vVariable)'},nDateMonth={'>=$(vStartMonth)'}>} [Budget])  /  $(vDividend)))/

((sum(TOTAL {< [Month End]={'$(vVariable)'},nDateMonth={'<$(vStartMonth)'}>} [Budget])  /  $(vDividend)) +

(sum(TOTAL {< [Month End]={'$(vVariable)'},nDateMonth={'>=$(vStartMonth)'}>} [Budget])  /  $(vDividend)))