Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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