Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Contributor III
Contributor III

Hello, 

Can you send a picture the associative model?

Not applicable
Author

What to you mean associative?

andrea_reyes
Contributor III
Contributor III

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

Not applicable
Author

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