how to make a table?

[vtatarnikov]

Hello!

If I join the tables in the script I spend a lot of memory. Is it possible to make such table tool of interface or some other way?

[Anonymous]

Hi,

Please elaborate on your question?

Like what is the database and what are your tables,fields,etc.

So can help.

Regards

Neetha

[vtatarnikov]

The difficulty is to compare the month of 2013 and month of 2014 on weekdays.

[Gysbert_Wassenaar]

See attached qvw

[vtatarnikov]

Gysbert, You help been most helpful!

[vtatarnikov · Accepted solution]

I solved the problem more gracefully:

1. create a serial number of week:

if((week(Date)=52 and num(month(Date))=1),0,if((week(Date)=1 and num(month(Date))=12),53,week(Date))) as SerialNumberOfWeek

2. create a key in calendar:

SerialNumberOfWeek & '-' & weekday as Key_NumberOfWeek_Weekday

3. Use the key as a dimension in straight table (hide column😞