topic Re: Two different date in QlikView

Two different date

smilingjohn — Mon, 01 Feb 2021 09:03:25 GMT

Hi All,

I have two dated one is "Order Date" and the second is "Update Date".

Now How can I get the common month from this two date and show the tickets raised

Thanks in Advance

Taoufiq_Zarra — Mon, 01 Feb 2021 09:05:36 GMT

@smilingjohn can you share a sample data and the expected output ?

sonkumamon — Mon, 01 Feb 2021 11:27:45 GMT

You can use a date bridge table:

DateBridge:

Load

TicketID

OrderDate as Date

'Order' as DateType

Load

TicketID

UpdateDate as Date

'Update' as DateType

And then in the chart you can use the Date field as the dimension, and as a measure use:

Count(Distinct TicketID)