Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
I forgot to mention they are using the DATA MANAGER