Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

Sure Sunny, adding the sample in a new thread.

Not applicable

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