Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tracycrown
Specialist
Specialist
‎2017-06-28 11:56 PM

YOY% Inc

Dear all

Kindly advise how to compute YOY% increase by products.

Correct Answer should be as follow :

 

ProductYear$YOY%
A108842015230000%
A10884201618000-22%
A10884201715000-17%
B645922015170000%
B6459220162400041%
B6459220173200033%

Thank You

Tracy

Labels (1)
Labels
YOY Increase.qvw
Testing-1.xlsx
839 Views
0 Likes
1 Solution

Accepted Solutions
antoniotiman
Master III
Master III
‎2017-06-29 12:10 AM

Hi Tracy,

see Attachment,

Regards,

Antonio.

View solution in original post

YOY Increase.qvw
737 Views
0 Likes
3 Replies
antoniotiman
Master III
Master III
‎2017-06-29 12:10 AM

Hi Tracy,

see Attachment,

Regards,

Antonio.

YOY Increase.qvw
738 Views
0 Likes
prma7799
Master III
Master III
‎2017-06-29 12:18 AM

PFA

YOY Increase.qvw
737 Views
0 Likes
pathiqvd
Creator III
Creator III
‎2017-06-29 12:25 AM

Hi,

    Use below expr you will get solution:-

num((sum(Sales)-above(sum(Sales)))/above(sum(Sales)),'##.## %')

Regards,

737 Views
0 Likes