topic Re: Crosstable attributes in QlikView

Crosstable attributes

Anonymous — Mon, 22 Jun 2015 11:04:17 GMT

I have created a crosstable and would like to generate the month for the field Week.So when i use the below script it doesnt seem to work and doesnt give me the month for the corresponding Week

Can anybody please help as I dont know whats going wrong with it?

Effort:
CrossTable(Week, Effort, 3)
LOAD *

FROM
XXX.xls
));

load *,
monthname(Week) as Month

Resident Effort

Re: Crosstable attributes

sunny_talwar — Mon, 22 Jun 2015 11:13:04 GMT

Seem right. Are you getting any errors when you run the script or is just that you don't see the field Month???

Re: Crosstable attributes

Anonymous — Mon, 22 Jun 2015 11:14:38 GMT

Hi Sunny

I dont get any errors while running the script. The column values for Month is blank

Re: Crosstable attributes

sunny_talwar — Mon, 22 Jun 2015 11:18:05 GMT

What is the format for your field Week when you load that into the application? It seems that week is a text field and isn't getting converted by MonthName.

You will need something like this:

load *,
MonthName(Date(Week, 'Week'sFormatHere')) as Month

MonthName(Date#(Week, 'Week'sFormatHere')) as Month

Resident Effort

Re: Crosstable attributes

hariprasadqv — Mon, 22 Jun 2015 11:19:17 GMT

Hi,

Load the three coulmns in respective order how you mentioned in Cross Table()

Re: Crosstable attributes

Anonymous — Mon, 22 Jun 2015 11:35:25 GMT

Hi Sunindia

I didnt really know that the values get stored as text. Also referred to Handling dates and cross table

Issue seems to have got solved.

Thanks

Re: Crosstable attributes

sunny_talwar — Mon, 22 Jun 2015 11:37:41 GMT

Awesome

I am glad it worked out for you.

Best,

Sunny