topic Re: Max / One row in QlikView

Max / One row

Anonymous — Mon, 11 Jan 2016 10:16:47 GMT

Hi again,

Order	Set	Description	Time
1-777888	1	XXX	Saturday, June 17, 1905
1-777888	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.

Re: Max / One row

sunny_talwar — Mon, 11 Jan 2016 12:49:30 GMT

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?

Re: Max / One row

Anonymous — Mon, 11 Jan 2016 12:53:29 GMT

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

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

Re: Max / One row

miguelbraga — Mon, 11 Jan 2016 12:54:42 GMT

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,

Re: Max / One row

Peter_Cammaert — Mon, 11 Jan 2016 13:08:30 GMT

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.

Re: Max / One row

ramasaisaksoft — Mon, 11 Jan 2016 14:24:27 GMT

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.