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: 
Not applicable

Issue with expression:

Hello,

Table1

I have two dimensions, Vintage and DLQT_STAT: And have an expression as Sum(Sales).

Now I have to create a new table.

Unable to explain the logic, I have created a excel with formula.

Table2 has same dimensions just need to change the expression. Any idea how I can achieve it?

Thanks,

Pavan

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi Pavan,

Hope, you are using pivot table. Then try this expression

Below(sum(Sales))/Before(sum(Sales))

Format should be, Fixed 2, percentage.

View solution in original post

5 Replies
sunny_talwar

Would you be able to share a qvw sample to play around with?

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Try using this:

Sum(Sales) / Sum(TOTAL Sales)

Also do not forget in Presentation tab to change numeric format:

Screenshot_1.jpg

Read more about TOTAL in expression and it's use in here:

The Aggregation Scope

What does the TOTAL qualifier do?

Not applicable
Author

Sure Sunny, adding the sample in a new thread.

Not applicable
Author

Hi Mindaugas, Its not that simple.

settu_periasamy
Master III
Master III

Hi Pavan,

Hope, you are using pivot table. Then try this expression

Below(sum(Sales))/Before(sum(Sales))

Format should be, Fixed 2, percentage.