Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Cracks,
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.
Any ideas?
Thanks a lot,
Thomas
The model_2 was the wrong attachment. Here the correct one.
Thomas
Does this expression work for you ?
sum ( { <transaction_month_id = month_id > } transaction_euro )
Best Regards, Bill
Hi Bill,
no sorry, I tried it.
The result of the formula is the same in every row.
It´s the total of sum(Transaction_euro).
Kind regards, Thomas
You can't make a reference within SetAnalysis to your current Dimension Value.
This is only done by IF statement
Regards,
Dirk
This wont work. If you need two time dimensions you will need two associated time tables (see also Ralph Kimball dimension role playing).
- Ralf
Ok, thanks.
So I have to read some pages of good old Kimball and make some changes on my data model.
Good to know that´s a waste of time to make experiments with set Analysis on that Topic.
Thomas