Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
crainerc
Contributor III
Contributor III

output the last date

I have created the following Table.

ArtNrabVK1VK2VK3VK4VK5EKPGKR
22000001

07.06.2005

3,894,093,694,254,451,4385
2200000103.01.20073,093,253,393,553,691,45378
2200000119.01.20073,093,253,393,553,691,45378
2200000310.05.20053,153,292,993,453,751,32376
2200000327.05.20053,153,292,993,453,751,32376
2200001326.04.200542,544,540,2948,552,9522,83345
2200001327.05.200542,544,540,2948,552,9522,83345
2200001308.06.20055,255,494,995,756,2522,8331
2200001322.06.200540,2940,2940,2940,2940,2922,83345

The end result should look like this:

ArtNrabVK1VK2VK3VK4VK5EKPGKR
2200000119.01.20073,093,253,393,553,691,45378
2200000327.05.20053,153,292,993,453,751,32376
2200001322.06.200540,2940,2940,2940,2940,2922,83345


Thanks a lot!

C.

1 Reply
johnw
Champion III
Champion III

If your "last date" doesn't need to respond to selections, the easiest might be to establish a new field during the load:

if(ArtNr<>previous(ArtNr),ab) as Lastab
...
ORDER BY ArtNr, ab DESC

And then use Lastab instead of ab as the dimension.