Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
eclecticfish
Contributor
Contributor

Bar chart with Time Dimension, Joins two tables on wrong keys (synth)

Hi im making a qlikview dahsboard which monitors orders and terminations.

All orders have a unique USER_ID. This is the one i want to join the two tables (New order) and (Terminated Orders) on.

However in the barchart i want the bottom dimension to be year_month. So i have added a year_month variable in each table (New Order) and (terminated orders)

The point is then to have a barchart which shows all new orders made during a month, and if these orders were terminated at a later date. I got this working using the approach above. Without the year_month variable in Terminated_orders it will think the order was made and terminated the same month. The picture below show this working as intended. But now come my problem. I have introduced a new bug.

Since i now have a synth key with user_id and year_month. my "terminated orders" table has lost connection with info in the new orders table. Since year_month in "New orders" will be different from the year_month in "terminated orders"

So if i choose all orders with terminated status in a selection box. i will not be able to see any order info from this order (like product, value, type etc)

So how do i make a chart like the one in the picture below, without this problem ?

 

Columns are New orders (blue bar) and Terminated orders this month (Red bar) and Accumulated Terminations (Green bar)

barchart.png

Labels (5)
2 Replies
Arthur_Fong
Partner
Partner

Try to resolve the synthetic keys before creating charts, as this would lead to misleading visualization.

Or attach a sample app you are working on.

Brett_Bleess
Support (Former)
Support (Former)

Kristian, here is a Design Blog post for you regarding synthetic keys, hopefully this will be helpful in relation to Arthur's post.

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.