Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Link Table

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.

4 Replies
andrea_reyes
New Contributor III

Re: Link Table

Hello, 

Can you send a picture the associative model?

Not applicable

Re: Link Table

What to you mean associative?

andrea_reyes
New Contributor III

Re: Link Table

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

Not applicable

Re: Link Table

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

Community Browser