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
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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: 
Anonymous
Not applicable
‎2018-07-04 03:56 PM

shows value and previous year

I would like to know how it shows value and previous year columnar

I have the Year 2017 and 2018 one on each line and both have the same destination and origin and also have freight value I will try to draw

<YEAR> ORIGIN> DESTINATION> FREIGHT VALUE> DIF ANO>

<2017> SP> MG> R $ 5000.00> 0>

<2018> SP> MG> R $ 3000.00> R $ 2000.00>

That if you had 2016 showed the difference between 2016 and 2017 also in the future will show years 2017 2018 2019 2020

I wanted this "DIF ANO" to be an expression without variable all leave the same table

Shipping Table: fields: Year, Origin, Destination, Value Freight.

This freight value is already = SUM (VALUE_FRETE) has many deliveries for those origin and destination and each origin and destination that I selected if it had delivery in two years showed that difference.

Thankful

610 Views
0 Likes
0 Replies