topic Re: how to make a table? in QlikView

how to make a table?

vtatarnikov — Tue, 23 Dec 2014 13:54:01 GMT

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 — Tue, 23 Dec 2014 14:00:58 GMT

Hi,

Please elaborate on your question?

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

So can help.

Regards

Neetha

vtatarnikov — Tue, 23 Dec 2014 14:15:51 GMT

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

Gysbert_Wassenaar — Tue, 23 Dec 2014 14:49:57 GMT

See attached qvw

vtatarnikov — Wed, 24 Dec 2014 12:57:25 GMT

Gysbert, You help been most helpful!

vtatarnikov — Fri, 26 Dec 2014 12:45:05 GMT

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😞