topic Re: Two dates as single date in QlikView

Two dates as single date

Abhi999 — Sat, 29 Aug 2020 21:37:46 GMT

Hi, could some one help on below scenario .

I dimension I have two rows orders received based on received date and delivered orders based on delivery date .

But in pivot table I need show like below

Ores type. Count of orders

Received. Count of order based on received date

Delivered. Count of orders based on delivered date

Re: Two dates as single date

jwjackso — Sat, 29 Aug 2020 21:56:48 GMT

Try Henric's Canonical Date

You will have date types, received and delivered. In the pivot table you you would have order type, canonical date, count(orders), count({<DateType={'received'>} orders),count({<DateType={'delivered'}>}

Re: Two dates as single date

Abhi999 — Sun, 30 Aug 2020 06:44:32 GMT

Two count statement in same exp not working.

Re: Two dates as single date

edwin — Tue, 01 Sep 2020 18:04:53 GMT

I would prefer to use a single calendar, this way you can use multiple date types in the same expression. as an alternative to the Canonical Calendar post, you can join the high level date fields into the lowest granular level. that way you have all your dates in one table - then create a bridge to a single calendar. this way for any date, you can determine how many units were ordered and shipped. in your case how many were ordered and delivered on specific date

Re: Two dates as single date

Brett_Bleess — Wed, 09 Sep 2020 15:58:14 GMT

@Abhi999 if Edwin's post got you what you needed, we would appreciate it if you closed out the thread by using the Accept as Solution button on the post to mark that as the solution. If you require further assistance leave an update, and if you did something different, you can post that and then use the button to mark that post too.

Regards,
Brett