Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
OLSP
Contributor II
Contributor II

Firstsortedvalue greater than Zero

Hi there,

I have a lot of data containing this information:

- transaction ID

- partner

- date (ENDE)

- number of offers (ANGEBOTE)

 

I would like to have a table with the date of the last offer of a partner. Unfortunately it is possible, that a partner didn't make an offer, so there is a 0 in the data. 

 

My formula works fine, but doe not exclude all date with offer = 0.

dimension: partner

expressions: 

date(Max(ENDE))

FirstSortedValue(ANGEBOTE, -ENDE)

 

How is it possible to exclude all date with offer = 0 from the formula?

I know that I could exclude them in the LOAD, but then some other formulas in the app wouldn't work anymore.

 

Thank you in advance and best regards

Oliver

1 Solution

Accepted Solutions
Kush
MVP
MVP

@OLSP  may be below

FirstSortedValue({<ANGEBOTE={">0"}>}ANGEBOTE, - ENDE)

View solution in original post

2 Replies
Kush
MVP
MVP

@OLSP  may be below

FirstSortedValue({<ANGEBOTE={">0"}>}ANGEBOTE, - ENDE)

View solution in original post

OLSP
Contributor II
Contributor II
Author

Thank you Kush, that was perfect help!

Also thank you for the very fast answer!

All the best for you, Oliver