Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show maximum value of the dimension aggregated over other dimension

Hello, I have a straight table with 6 dimensions, no expressions – I do not need expressions because all the data I need to show is already in the model.

PO Number

Doc Type

Delivery Date

Order Value (ex. VAT)

Outstanding Value

Delay

4500000001

Standard PO

09/06/2015

100

100

22

4500000002

Standard PO

29/04/2015

200

200

63

4500000003

Standard PO

22/06/2015

300

300

9

4500000004

Standard PO

26/03/2015

400

400

97

4500000005

Standard PO

05/05/2015

500

500

57

4500000005

Standard PO

15/05/2015

500

500

47

Out of those dimensions all but two come from one table (POs). Only Delivery Date and Delay comes from different table (PO items). PO 4500000005 have two dates and delays in the straight table because for this PO exists two items with different dates.

Now, what I want to do is to show only one row (with the later date) for one PO in this table. So PO 4500000005 should only have one line with 15/05/2015 delivery date and 47 Delay Days.

Could you please advise how this can be achieved? I am attaching sample application as well.

Thank you,
Mat

2 Replies
Anonymous
Not applicable
Author

with a Workaround i got it

create an Expression maxstring(Delivery date) but hide them (prersentation)

define Dimension Limit for delivery date and don't Show others

look at my solution !

padmaja_gade
Contributor III
Contributor III

Try this as an expression

=if(max(TOTAL <[PO Number]> [Delivery Date])=[Delivery Date], Delay)