Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

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
Partner

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

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