topic Conversion in QlikView

Conversion

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi ALl,

I have a excel in which the Month names are horizontal and are in text format

I created a cross table and converted to month format .

But still the date is not matching I am not sure the months are created in proper date month format .

Please find the attachment .And let me know if iam doing the right way.

Can please someone sugegst me on this

Thanks

antoniotiman — Wed, 03 Aug 2016 07:13:03 GMT

Hi John,

it seems correct.

Month is Dual Field

Min(Month) -> 1

MinString(Month) -> Jan.

Regards,

Antonio

smilingjohn — Wed, 03 Aug 2016 07:32:00 GMT

Hi Antonio

Do i need to add the above code in my script or how it is ?

antoniotiman — Wed, 03 Aug 2016 07:34:05 GMT

No John,

this is only for test if Month is correctly Dual Field

smilingjohn — Wed, 03 Aug 2016 09:00:44 GMT

When i try to include one more table which also has a date format, then this date dont work with that .

antoniotiman — Wed, 03 Aug 2016 09:06:33 GMT

What is Your new table and new Format Date ?

smilingjohn — Wed, 03 Aug 2016 09:37:52 GMT

The new format of data is coming from Excel which is like

1-Jan-07

.30-Dec-09

antoniotiman — Wed, 03 Aug 2016 09:43:53 GMT

Month(Date#(DateField,'DD-MMM-YY')) as Month

smilingjohn — Wed, 03 Aug 2016 09:54:13 GMT

Do i need to change the format as

Month(Date#(DateField,'DD-MMM-YY')) as Month

For the month for attached QVW ? or it for the new date

antoniotiman — Wed, 03 Aug 2016 09:58:28 GMT

For the new table