topic Re: Re: Getting dates for max usage value in QlikView

Getting dates for max usage value

Tue, 17 Jun 2014 11:57:27 GMT

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

Gysbert_Wassenaar — Tue, 17 Jun 2014 12:02:36 GMT

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

Tue, 17 Jun 2014 14:04:57 GMT

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

this is the data.

Anonymous — Tue, 17 Jun 2014 14:06:47 GMT

Try aggr functions.

You can check the below post

Gysbert_Wassenaar — Tue, 17 Jun 2014 14:25:24 GMT

See attached qvw.

Tue, 17 Jun 2014 14:27:49 GMT

Thanks I managed also.

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