Max / One row

[Anonymous]

Hi again,

Order	Set	Description	Time
1-777888	1	XXX	Saturday, June 17, 1905
	2	YYY	Saturday, June 17, 1905

How can i show only one row  ?

i have the same order number and different set , the time is the same.

[sunny_talwar]

Two questions:

1) Are you trying to get ride of one of the rows in the script or just on the front end?

2) Which row would you like to hide: Set = 1 or Set = 2?

[Anonymous]

It would not be possible as associative nature of Qlik...

In your case OrderID in unique but Set & Description is different..

[miguelbraga]

Hi,

Can you please send us a qvw sample or a qvd or even a screenshot of your table? Do you want to remove all the rows except the first one with the same Order ID? Can you please describe better your issue?

Regards,

MB

[Peter_Cammaert]

In a User Interface Object (like a straight table), remove all dimensions that you don't need (like Set and Description). There will only one row for each unique combination of "Order" and "Time".

As an alternative (and if you want to keep displaying all values for Set), remove Set as a dimlension column, and add it as an expression like:

=Concat(Set, ', ')

All values for Set that go with this unque combination of Order & Time, will now be listed as a single string.

[ramasaisaksoft · Accepted solution]

Hi Naor,

in expression u can write like below

=aggr(max(set),[ord id])

but i hope all order id 's  need to be fill with some value no null values.