Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create an expression to calculate the Vertical Analysis

In this attachment “example.qvw”, what I should do to make the category “B” the reference of the expression “VA” and make the correct calculation in percentage? The result should be exactly as the attachment “example.xlsx”.

1 Solution

Accepted Solutions
Not applicable
Author

Check the uploaded doc

View solution in original post

6 Replies
Not applicable
Author

Check the uploaded doc

View solution in original post

fernando_tonial
Partner
Partner

Hi, you can try this.

Value / Top(Value,2)

OR

Value / Sum({$<category={'B'}>} total<business> value)

Best Regards.

Tonial.

mov
Champion III
Champion III

This expression works:

(value) / sum({$<category={'B'}>} total<business> value)

Not applicable
Author

Attached with answer.

Thanks

AJ

mehmet_caldak
Partner
Partner

Hi,

Try Below function as i did in the attached example.

Not applicable
Author

It works!!!!

Thanks...

Best Regards.

Permirio.