topic How to show identical transactions in a table in seperate rows without using the ORDERID? in App Development

How to show identical transactions in a table in seperate rows without using the ORDERID?

mwallman — Wed, 19 Sep 2018 08:57:21 GMT

Hi,

I have a Orders table like this:

OrderID	Date	CustomerName	Value
3434	19/09/2018	Bob Ltd	32
3221	19/09/2018	Bob Ltd	32

In Qlik in the user interface when I create a table with Date, CustomerName, and Value it puts the above in a aggregated way.

How can I show the transactions uniquely without inserting the OrderID please?

Ivan_Bozov — Wed, 19 Sep 2018 09:25:09 GMT

Set the date as follows: =DUAL(Date, OrderID)

timpoismans — Wed, 19 Sep 2018 10:23:31 GMT

Although I'm not the owner of the thread, I did a quick test and it works.

Didn't know it would work like that, so thanks from me as well ^^

joseph_eftamand — Wed, 19 Sep 2018 10:30:53 GMT

The above should work, but you can also hide the column:

Straight Table properties -> presentation -> select column -> hide column.

mwallman — Wed, 19 Sep 2018 10:43:25 GMT

Hi,

This option I think is for QlikView, not Qlik Sense.

mwallman — Wed, 19 Sep 2018 10:44:33 GMT

Thank you Ivan you are a star