Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting dates for max usage value

Hi all,

I have this fact table schema:

Subscriber_key|Amount|date;

I want to create a table which will give me the next output:

distinct (subscriber_key) | max(amount) | date (corresponding one);

I tried creating a straight table, used subscriber_key as a dimension and the max(amount) and date as expressions.

I got an empty cells in the date.

can someone advice how we can do such object? and if it's even possible with one iterration?

Thanks,

Kacevich Boris

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Create a straight table or pivot table with subscriber_key as dimension and two expressions: max(amount) and firstsortedvalue(date, -amount).


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

Create a straight table or pivot table with subscriber_key as dimension and two expressions: max(amount) and firstsortedvalue(date, -amount).


talk is cheap, supply exceeds demand
Not applicable
Author

Didn't work, still get an empty value in the corresponding date field.

subsriberkeyTuamountdate
171/1/2014
162/1/2014
153/2/2014
293/2/2014
282/1/2014
271/1/2014
343/2/2014
362/1/2014
371/1/2014
493/2/2014
422/1/2014
4101/1/2014

this is the data.

jebamalai
Specialist
Specialist

Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks I managed also.

figures out that qlikview doesn't like copied statements and only typed in.