topic Re: Link Table in QlikView

Link Table

Tue, 29 Jul 2014 20:46:10 GMT

Hi.

I created a linked table with field YearMonth as my key field.

I have in my script a calculated filed that tells the Qtr of a specific month.

For Example:

Date Month Qtr

06/15/2014 06 2

When I chose the Qtr '4' and not months 10,11,12

the data displayed is not the same.

I assume it's because the Linked Table.

What could be the result for that?

Thank You.

Anonymous — Tue, 29 Jul 2014 21:41:09 GMT

Hello,

Can you send a picture the associative model?

Tue, 29 Jul 2014 21:53:21 GMT

What to you mean associative?

Anonymous — Tue, 29 Jul 2014 22:23:39 GMT

It is the model that is generated by relating the tables. You can see it by doing ctrl + T.

Wed, 30 Jul 2014 18:39:06 GMT

I load my table from sql

select

month(line_date),

quarter = if month> 9 then 'q4' else

if month > 6 then 'q3' else

if month >3 then 'q2' else

if month > 0 then 'q1' else ' error!'

endif end if endf endif