Discussion Board for collaboration on QlikView Scripting.
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.
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?
Can you send a picture the associative model?
What to you mean associative?
It is the model that is generated by relating the tables. You can see it by doing ctrl + T.
I load my table from sql
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