topic Calculated dimension in QlikView

Calculated dimension

Mon, 14 Oct 2013 18:13:01 GMT

How do I create a new calculated dimension from the sql load script?

I am loading date from sql query and would like to calculate week during load.
The below code works, but I cannot see WorkWeek as a dimension after load completes.

SELECT Epi_Lot.Start_Date
FROM BlueDB.dbo.table;
Let WorkWeek = Week(start_date);

Re: Calculated dimension

Mon, 14 Oct 2013 18:17:38 GMT

You can do the same thing on your script
LOAD *,

Week(Start_Date) as WorkWeek;

SQL

SELECT Epi_Lot.Start_Date

FROM BlueDB.dbo.table;

Hope this helps

Regards

Pablo

Re: Calculated dimension

rustyfishbones — Mon, 14 Oct 2013 18:18:24 GMT

you can try this

MainTable:

SELECT Epi_Lot.Start_Date

FROM BlueDB.dbo.table;

	Week:
	Load distinct
		Week(Start_Date) AS Week,

Resident MainTable;

Re: Calculated dimension

rustyfishbones — Mon, 14 Oct 2013 18:20:51 GMT

here is an image of something similar

Re: Calculated dimension

Clever_Anjos — Mon, 14 Oct 2013 18:28:33 GMT

LOAD

Week(Start_Date) AS Week;

SELECT

Epi_Lot.Start_Date,

FROM BlueDB.dbo.table;

Re: Calculated dimension

Mon, 14 Oct 2013 18:41:00 GMT

This works! The examples helped. Thanks everyone.

Re: Calculated dimension

rustyfishbones — Mon, 14 Oct 2013 18:43:24 GMT

That's great Susan.

You need to mark the correct answer to help others in the community find the correct answers to similar questions