topic Re: Dashboard with different insights in QlikView

Dashboard with different insights

tomgrouwe — Wed, 25 Nov 2020 16:16:04 GMT

Dear experts,

Can you guys help me with the following problem.

I've developed a dashboard for a transportation ustomer based on a excel document. In the enclosed Qlikview file you can see the graph 'First time right carrier'. What the customer wants to know is; How many times did a A carrier (see tab 'detailed report') reject the load and is it passed through to a Check Carrier (The Check carrier will eventually be the executive carrier). The whole dashboard is based on the executive carrier but only graph 'First time right carrier' needs to be based on the A carrier.

It's hard to explain so I'll understand if not clear.

Is there a way to accomplish this?

Re: Dashboard with different insights

sunny_talwar — Thu, 19 Oct 2017 12:24:26 GMT

What are expected value you are looking to get for the chart?

Re: Dashboard with different insights

tomgrouwe — Thu, 19 Oct 2017 12:28:33 GMT

If i select carrier 'A' in my filter. graph 'First time right' needs to display how many times carrier 'a' isn't the executive carrier. The expression isn't that difficult. The only problem is that my dashboard is based on executive carriers and only this field is based on A carriers.

Re: Dashboard with different insights

sunny_talwar — Thu, 19 Oct 2017 12:36:30 GMT

Right now when I select A, I see this

But I guess this is not what you want? What is the expected output you are looking for?

Re: Dashboard with different insights

tomgrouwe — Thu, 19 Oct 2017 12:53:49 GMT

That's right. With the current selection you can see that the data is based on carrier 'A' as a executive carrier (Ecarrier). In this case i want to know how many times carrier 'A' rejected it's order. So it needs to be based on field 'A carrier' because the executive carrier doesn't want to recive the hit, that he rejected the order.

Re: Dashboard with different insights

pradosh_thakur — Thu, 19 Oct 2017 13:00:22 GMT

if you want the count where A carrier passed on to C carrier and then it becomes ECareer or where Acarrier not equal to E carrier then find the attached.

regards

Pradosh

Re: Dashboard with different insights

tomgrouwe — Thu, 19 Oct 2017 13:16:03 GMT

Hopefully, this clarifies.

Re: Dashboard with different insights

pradosh_thakur — Thu, 19 Oct 2017 13:31:06 GMT

What about this ?

is this what you are looking for?

edit: updated the app

regards

Pradosh

Re: Dashboard with different insights

tomgrouwe — Fri, 20 Oct 2017 07:10:02 GMT

Hello Pradosh,

This is the desired results. But the value doesn't change when i select a other carrier. I can see that you used 'A' in the expression. Is there a way to get the same kind of result when I select a other carrier?

Re: Dashboard with different insights

pradosh_thakur — Fri, 20 Oct 2017 07:19:43 GMT

you want only for carrier 'A' or all the carriers that are listed in field "Carrier A" ? sorry . due to the names its a bit confusing .

if you select any filter other than e carrier the value will change. do you want Ecarrier to make an impact too ?

edit: attached is the dashboard

Re: Dashboard with different insights

tomgrouwe — Fri, 20 Oct 2017 07:46:46 GMT

For all carriers. I'll try to explain the situation as clear as possible.

We have a customer that has selected 5 carriers to perform transports for him. I need to take care of administration, communication with the carriers for this customer so they don't have to. The customer does want to know how the carriers perform and therefor this scorecard.

Carriers are selected for certain transport. They are the "A carrier" on these transports. However it is possible that the "A carrier" doesn't have enough resources to perform the transport. As a backup, the customer also selected a "Check carrier" on each transport. So when the "A carrier" cannot perform the transport, "Check carrier" will stand in, and will be the "executive carrier". When the "A carrier" can perform the transport, the "Check carrier" will not be needed and the "A carrier" will be the "Executive carrier".

The customer wants a report about the performance of his carriers. Graph "No of loads", "Loading performance" and "Delivery performance" are about actual performance. So this graphs are about the carrier that actually performed the work. That is in this case the "Executive carrier". This is also the filter and listbox for the dashboard.

Next to this, the customer also wants to know how many times a "A carrier" didn't have enough resources and needs to decline the transport. In the customers eyes he failed to keep his end of the bargain. So they want to know how many times this happened. This score needs to be combined with the actual performance that the carrier delivered so the customer can see in one dashboard how his carriers are performing and how many transport they declined.

Hopefully this helps.

Re: Dashboard with different insights

pradosh_thakur — Fri, 20 Oct 2017 07:54:03 GMT

Check this out

regards

Pradosh

Re: Dashboard with different insights

tomgrouwe — Fri, 20 Oct 2017 08:07:40 GMT

Yeah this seems to be the right expression.

But in the dashboard I select carrier "D". Now, it doesn't show the right amount because it still looks up "D" as an executive carrier and not as an A carrier.

Re: Dashboard with different insights

pradosh_thakur — Fri, 20 Oct 2017 09:14:41 GMT

i have done some adjustment and tried to make it the way you want . still i will recommend a new filter because when you select Ecarrier the related month will be associated with it not the month related to Acarrier.

anyway try it once and let me know.

regards

Pradosh

Re: Dashboard with different insights

tomgrouwe — Fri, 20 Oct 2017 09:24:02 GMT

Hi Pradosh,

Thanks for your help. This seems to be working partially.

I think you're right and savest way is to add a new tab with a listbox filter on 'a carrier'.

Afterall, many thanks for your help. Learned a lot!

Re: Dashboard with different insights

pradosh_thakur — Fri, 20 Oct 2017 09:29:16 GMT

I will still work on this and will update you. you can mark answers helpful and may be close the thread by answered/ assume answered.

regards

Pradosh