Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Sales greater than previous year

Hi all,

 

This is the interview questions.

 

There is table having companies sales yearwise.

 

Now I want to fetch company names which have more sales than previous year.

 

Can any one tell me that..how to approach this solution

 

 

Kind regards

Adarsh

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Create a table with company as dimension and this expression

=If(Sum( {<year={$(=max(year))}>}sales) 

>

Sum( {<year={$(=max(year)-1)}>}sales), 'Greater than previous year')

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

Create a table with company as dimension and this expression

=If(Sum( {<year={$(=max(year))}>}sales) 

>

Sum( {<year={$(=max(year)-1)}>}sales), 'Greater than previous year')

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post