Forum Discussion

Draszor's avatar
Draszor
Icon for Helper III rankHelper III
5 years ago
Solved

Lookup values from another table while keeping the visual filter context

Dear All,   I have 3 tables: FINANCIALS - table containing transactional data for projects (the same project repeats many times, ther are dates for the transaction etc) PROJECT_NAME - table conta...
Need Help
  • Draszor's avatar
    Draszor
    5 years ago

    Hi Paul Zheng, 

     

    I was trying few solutions. when I linked PROJECT_BUDGET table to FINANCIALS (or linked it to PROJECT NAME, that was linked to FINANCIALS) then in certain scenarios I was getting desired results, however all projects from PROJECT_BUDGET were expanded in the visual. 

    My ned was to get only those projects that have financials, so only those that are present in FINANCIAL table. this works fine with keeping the tables not linked and using Selectedvalue.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Draszor 

I am not sure about your model, and Selectedvalue() only works when using unrelated table. However, glad you solved it.

 

 

Paul Zheng _ Community Support Team

  • Draszor's avatar
    Draszor
    Icon for Helper III rankHelper III
    5 years ago

    Hi Paul Zheng, 

     

    I was trying few solutions. when I linked PROJECT_BUDGET table to FINANCIALS (or linked it to PROJECT NAME, that was linked to FINANCIALS) then in certain scenarios I was getting desired results, however all projects from PROJECT_BUDGET were expanded in the visual. 

    My ned was to get only those projects that have financials, so only those that are present in FINANCIAL table. this works fine with keeping the tables not linked and using Selectedvalue.