Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
sayanpwc
Partner
Partner

latest date vs last date sales price growth

Hi friends,

Need a help urgently pls.

I have a data like this.

a.PNG

I have chart that shows date wise sales trend for each material based on material selection in listbox.

b.PNG

Now my requirement is to show for each product the % growth of sales from its latest date vs last date sales. and it will be shown on a text box on top of the gap between those dates.

So for ex: for product b sales growth % should be (700-600)/600*100 which is around 17 %

for product a this would be (400-200)/200*100 which is 100 %.

How can i do this?? pls help

1 Reply
tresesco
MVP
MVP

Select a product to see it's growth in text box. Text box expression like:

=

(     Sum({<sale_date={'$(=Date(Max(sale_date)))'}>}sale) -

     1/Sum({<sale_date={'$(=Date(Max(sale_date, 2)))'}>}sale)

)

*100