topic Re: how to get common month name from two time stamps? in QlikView

.

xyz1 — Sun, 14 Apr 2019 11:30:23 GMT

Re: how to get common month name from two time stamps?

dsharmaqv — Tue, 31 Jan 2017 11:21:01 GMT

Hi In the load script you can generate flag, try this

If(Month(Date#(Creation Date, 'MM-DD-YYYY'))=Month(Date#(Accounted for, 'MM-DD-YYYY')),'Flag')

Re: how to get common month name from two time stamps?

rahulpawarb — Tue, 31 Jan 2017 11:59:03 GMT

Hello Agrim,

Trust that you are doing good!

If the Creation Date and Accounted For fields have same month for every records then you can opt for - Month([Creation Date]) AS Month or Month([Accounted For]) AS Month

However, if a record has different month values then you have to have a priority in place i.e. from which field to choose month. In below given example I am selecting Month where it greater in both of fields.

If(Month([Creation Date]) > Month([Accounted For]), Month([Creation Date]), Month([Accounted For])) AS Month

Hope this makes sense.

Regards!

Rahul

Re: how to get common month name from two time stamps?

sdmech81 — Tue, 31 Jan 2017 12:30:54 GMT

If you can boil down to one date then it would just using month() function.

Else if u expect dash board act as per more than 1 date then,

1) plss check this out Canonical Date

or 2)You can concatenate both date data and then flag acoordingly to use..

sachin

Re: how to get common month name from two time stamps?

jcampbell474 — Tue, 31 Jan 2017 13:08:43 GMT

Can you just do two loads (either from the data source or resident) - 1) Creation Date 2) Accounted for.

Add a column in each for the month. Use month([Creation Date] as monthkey and month([Accounted for]) as monthkey.

Concatenate the tables.

Use monthkey as a Dimension and count distinct either the Number or Category fields. Or, whatever field you prefer.

Using this will also allow you chart occurrences per category too (if needed).

Re: how to get common month name from two time stamps?

MarcoWedel — Tue, 31 Jan 2017 23:01:28 GMT

please provide sample application to demonstrate.

thanks

regards

Marco

Re: how to get common month name from two time stamps?

xyz1 — Sun, 14 Apr 2019 11:31:06 GMT

Re: how to get common month name from two time stamps?

xyz1 — Sun, 14 Apr 2019 11:31:36 GMT

Re: how to get common month name from two time stamps?

kaushiknsolanki — Wed, 01 Feb 2017 05:53:50 GMT

Hi,

You can try this script,

LOAD

"Creation Date" as Date,

Number,

month([Creation Date] )as Month,

Category,

'Creation' as Flag

FROM [lib://Sample/Sample Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

concatenate

LOAD

Number,

"Accounted for" as Date,

month([Accounted for] )as Month,

Category,

'Accounted' as Flag

FROM [lib://Sample/Sample Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Also see attached qvf.

Regards,

Kaushik Solanki

?

xyz1 — Sun, 14 Apr 2019 17:14:55 GMT

Re: how to get common month name from two time stamps?

xyz1 — Sun, 14 Apr 2019 11:32:31 GMT

Re: how to get common month name from two time stamps?

kaushiknsolanki — Wed, 01 Feb 2017 07:07:49 GMT

What else help you need. If its related then cont. here else create a new post.

Feel free to post.

Regards,

Kaushik Solanki

?

xyz1 — Sun, 14 Apr 2019 17:13:29 GMT

Re: how to get common month name from two time stamps?

kaushiknsolanki — Wed, 01 Feb 2017 07:15:06 GMT

Hi,,

Same way as Month is created, All you need to do is replace Month function with Year Function.

If new data gets added it will automatically calculate it.

Regards,

Kaushik Solanki

?

xyz1 — Sun, 14 Apr 2019 17:13:57 GMT

Re: how to get common month name from two time stamps?

kaushiknsolanki — Wed, 01 Feb 2017 07:41:52 GMT

Anytime.

Regards,

Kaushik Solanki