Defining a Calendar

Fri, 20 Nov 2020 18:02:30 GMT

Dear All,

I have multiple calendars in my data. One is the registration date, another is the Energization date. The issue I have is that i want to display the number of registrations and energizations in a single month year in a table. Since these are different dimensions in my data model i am unable to do so. I want a table in the following format:

Month Year Registered Cases Energized Cases

jan 2015 xyz abc

feb 2015 djfh dkj

I tried making a pivot table using the MonthName field that i have that relates to all dates. Then i added the followng expression fro registred cases but it is not working:dsf

count({<MonthName=[Registration Month]>}Distinct [Case ID])

Similarly for Energized i replaced the Registration month with energized month.

Please help!!

Re: Defining a Calendar

Anonymous — Fri, 27 Mar 2015 16:47:36 GMT

You need to tag the different tables in the script. In my case I have two tables, one with shipments and shipment dates and one with orders and order dates. In each table I create a new row in Orders like this 'Orders' As Transtype and in Shipments 'Shipments' As Transtype. I then rename the datefield in each table to Dates and concatenate the tables. not sure if this will work in your case but this is just to show how I set it up.

I can then use the same date but still seperate the source based on the Transtype field.

In a table it would look like this using two expressions

Count( {$<TransType= {'Shipments'} >}DISTINCT OrderID ) and

Count( {$<TransType= {'Orders'} >}DISTINCT OrderID )

topic Re: Defining a Calendar in QlikView

Defining a Calendar

Re: Defining a Calendar