QlikView App Dev

[#1]

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 · Accepted solution]

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

[#3]

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

subsriberkey	Tuamount	date
1	7	1/1/2014
1	6	2/1/2014
1	5	3/2/2014
2	9	3/2/2014
2	8	2/1/2014
2	7	1/1/2014
3	4	3/2/2014
3	6	2/1/2014
3	7	1/1/2014
4	9	3/2/2014
4	2	2/1/2014
4	10	1/1/2014

this is the data.

[jebamalai]

Try aggr functions.

You can check the below post

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/16/use-the-aggregation-functions

[Gysbert_Wassenaar]

See attached qvw.

[#6]

Thanks I managed also.

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