Table Structure - How to handle loop

Sun, 20 Mar 2011 13:01:09 GMT

Dear All,

I have a file with below table structure:

Some of the table has weekly base detail and some of them has daily base detail. So I have connected all of the over MAster Calendar. But I also want to connect my tables over Hat, Hat1, Hat2 and Hat3 (Green circles on the snaphot). How can I succeed it?

Thanks for your support.

Best regards,

Table Structure - How to handle loop

erichshiino — Sat, 16 Apr 2011 04:43:13 GMT

This answer may apply depending on your data, ok?

Can you concatenate all the tables except for the calendar. Then you will use only one hat field.

You can transform calendarweek, calendarmonth and calendardates just on dates and then create a master calendar. For weeks and months, just transform it on the first day of the week or month.

After this, you need to handle the different timeframes on the interface (weekly analysis for weekly data and so on).

We can discuss you model a bit more if you prefer.

topic Table Structure - How to handle loop in QlikView

Table Structure - How to handle loop

Table Structure - How to handle loop