Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis; use of external dimension

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

6 Replies
Not applicable
Author

The model_2 was the wrong attachment. Here the correct one.

bill_markham
Champion III
Champion III

Thomas

Does this expression work for you ?

     sum ( { <transaction_month_id = month_id > } transaction_euro )

Best Regards,     Bill

Not applicable
Author

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


dirk_konings
Creator III
Creator III

You can't make a reference within SetAnalysis to your current Dimension Value.

This is only done by IF statement

Regards,

Dirk

rbecher
MVP
MVP

This wont work. If you need two time dimensions you will need two associated time tables (see also Ralph Kimball dimension role playing).

- Ralf

Vizlib Head of R&D
Not applicable
Author


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