topic Re: Scorecard chart in Qlikview in QlikView

Scorecard chart in Qlikview

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

Guys,

I have the below requirements,

1. If a Customer_Name is selected from the listbox, I want to show other customers who are having same mapping of the selected customer. (i.e) other customers having the mapping of selected customer.

In the above screenshot, Customer_Name "Hapag Lloyd" is selected in the list-box. For that selection, two customers (Cargosmart and Maersk) having the same mapping of "Hapag Lloyd".

For this I have used the below expression,

=Count({<Customer_Name= E(Customer_Name),Mapping = P(Mapping)>}FieldName)

Now, what I need is

1. If a Customer is selected from the table, it has to show that fields in the table. For example if "Cargosmart" is selected in the table, it should show only the count of that customer irrespective of other customers.

Since I have used E(Customer_Name) in the expression, I can't do this. Plz suggest if any other way is possible to do this.

Thanks in advance.

Re: Scorecard chart in Qlikview

Digvijay_Singh — Mon, 15 May 2017 18:20:57 GMT

Can you check what you get from this? and without '1-$'

=Count({<Customer_Name= P({1-$<Mapping = P(Mapping)>}Customer_Name)>}FieldName)

Re: Scorecard chart in Qlikview

Anonymous — Mon, 15 May 2017 18:57:16 GMT

Yes I got the count. But what my requirement is, when customer is selected from the table it has to show the data for selected customer. I couldn't do it since I have used this expression in it.

Re: Scorecard chart in Qlikview

Anonymous — Mon, 15 May 2017 18:59:11 GMT

Instead it is drilled down to the data of other customers. I don't want that. I want to show it for current customer selection.

Re: Scorecard chart in Qlikview

Anonymous — Mon, 15 May 2017 19:26:03 GMT

could you provide some sample data please and the expected result...?!?

Re: Scorecard chart in Qlikview

Digvijay_Singh — Mon, 15 May 2017 19:26:25 GMT

If possible can you share small sample to try different options to work out the solution

Re: Scorecard chart in Qlikview

Digvijay_Singh — Mon, 15 May 2017 22:27:23 GMT

I think the functionality you want to achieve is not possible as two of your actions are contradicting each other.

In first action you are selecting customer from list box and you want to show all other customers having same mapping but you don't want to show the selected customer.

In your next action you want to select the record from the straight table and want to show only that record in the straight table but when you select record in the straight table, in reality it selects the customer dimension and that would make selection in list box also, so here the contradiction happens as you cannot have the selected customer in straight table(the count expression excludes it) as well as in the list box.

I was trying one option with below attached sample -

Re: Scorecard chart in Qlikview

Anonymous — Tue, 16 May 2017 14:29:01 GMT

Thank you so much for your reply Digvijay. I'll make use of this, but I also want to pick the count of fields for those 2 customers..(MNO and PQR).

Re: Scorecard chart in Qlikview

Anonymous — Tue, 16 May 2017 14:48:19 GMT

Sorry Robin, I couldn't provide the sample data as I'm not having now. I'm doing some sample requirements as of now.

Re: Scorecard chart in Qlikview

Digvijay_Singh — Tue, 16 May 2017 15:59:06 GMT

May be this -