I´m searching for a solution to use an external dimension in a Chart.
There are 2 tables:
t_month with one column month_id
t_transaction with column Transaction_euro and Transaction_month_id
To avoid data circles in a more complex data model I don´t want to join the two tables with the month_id. In fact I want to synchronise 2 and more indepent time-dimensions, and my idea is to do that with formulas depending on one timetable.
The target here is to find a formula that sums up the Transaction_euro by month_id.
In the attached file in column 3 there is a formula with an if-Statement. It works, but I want to replace it with set Analysis due to Performance respects. Columns 4 - x are my tries...
As you can see, I´m definitly not an qlikview-formula-hero.