show value based table dimension

[havfunsherlock]

hi. i have 2 table

table 1:

month_sales       sales

table 2:

month_target    target

i create table chart with month dimension from  date_sales table 1.

i want to show table like this:

month                  sales                     target

januari                -                                     -

februari            -                                      -

i try: sum({<month_target=month_sales>}target) for meassure target, but it's not working

is it possible to show target meassure based month dimension from table1

[Rohan]

Hello,

 I think this is happening because there is no association(link) between the two tables.

You should Rename both the month fields as "Month". Then you only need to take Sum(Sales) & Sum(Target) as measures & Month as Dimension in a straight table on Front End.

Let me know if you have any queries or if this doesn't work.

Thanks & Regards.

Rohan S. Desai

[havfunsherlock]

actually the table have field "region" that link table 1 to table 2.

i get month dimension from qliksense autocalendar script.

so it becomes circular reference if i link the date. the date from table 1 and table 2 have a different function on my apps

[Rohan]

Hey, 

Can You upload a pic of your data model or a sample data model which can show me the linkage of the tables ?

& I think you should try simply adding Sum(Sales) & Sum (Target) as a measure in that table & check if it works with out any set expression.

Thanks & Regards.