Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Joining tables on self multiple times

Good Morning,

I am Administering a Qlik Sense site but do not develop in it and rather new, ie...Creating dashboards. Our BA's do this and they have been running into problems trying to join QVD's on themselves, I am looking for a way to do this without having to create special QVD's for them.

Here is an example of what they are trying to do. If someone has or if there is a way to do this in QLIK SENSE, could someone advice? Thank You

                       SELECT     PO_NUMBER, KILL_DATE4 AS KILL_DATE, BRAND1 AS BRAND

                       FROM         [WV-SQL01].[LIVE_OPERATIONS].[DBO].[EGG_PURCHASE_ORDER] AS EGG_PURCHASE_ORDER_2

                       WHERE     (KILL_DATE4 > '01/01/2000')

                       UNION ALL

                       SELECT     PO_NUMBER, KILL_DATE5 AS KILL_DATE, BRAND1 AS BRAND

                       FROM        [WV-SQL01].[LIVE_OPERATIONS].[DBO].[EGG_PURCHASE_ORDER] AS EGG_PURCHASE_ORDER_1

                       WHERE     (KILL_DATE5 > '01/01/2000')

                       UNION ALL

                       SELECT     PO_NUMBER, KILL_DATE6 AS KILL_DATE, BRAND1 AS BRAND

                       FROM         [WV-SQL01].[LIVE_OPERATIONS].[DBO].[EGG_PURCHASE_ORDER] AS EGG_PURCHASE_ORDER_1

                       WHERE     (KILL_DATE6 > '01/01/2000')

1 Reply
Not applicable

Re: Joining tables on self multiple times

I forgot to mention they are using the DATA MANAGER