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

[mwallman]

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

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

[timpoismans]

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]

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

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

[mwallman]

Hi,

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

[mwallman]

Thank you Ivan you are a star