topic Re: How to compare fields in QlikView

How to compare fields

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

Guys,

In the below screenshot, I have two customers A and B with having some number of fields each.

1. When customer A is selected in list-box,I want to show a bar chart with having the fields exactly matched with customer B

2. The selected customer (A) need not be shown in bar chart. If selected customer's fields exactly matches with customer B, that matched field count alone for customer B should be shown.

How can I achieve this... Plz anyone help me guys.

Regards,

Siva

Re: How to compare fields

Anil_Babu_Samineni — Tue, 11 Jul 2017 13:24:34 GMT

1) On what bases?

2) Does it mean this?

Only({<Customer = {B} >} Yourdatapointfieldname)

Re: How to compare fields

Anonymous — Tue, 11 Jul 2017 14:03:03 GMT

No,If we have three customers A,B and C, and if customer A is selected we have to show the matched fields count for customers excluding the selected customer A i.e Customer B and C.

But all the fields should be matched with customer A. Also attached sample data.

Here, in below example we have 3 customers,

"Hapag Lloyd" is selected and I need the matched fields count in "Cargosmart" and "Maersk" as shown below.

Hapag Lloyd - 8 fields

Cargosmart - 10 fields and

Maersk - 6 fields

Out of 10 fields of Cargosmart, 5 fields matched with Hapag Lloyd and out of 6 fields of Maersk, 4 fields matched with Hapag Lloyd as shown in the chart below.

I need to show this chart based on the appropriate selections of customer.

It has to compare the matched fields with all the customers excluding the selected customer.

Re: How to compare fields

Anil_Babu_Samineni — Tue, 11 Jul 2017 14:26:08 GMT

I haven't check your excel file, May be this?

Sum({<Customer = E(Customer)>}Sales)

Re: How to compare fields

Anonymous — Tue, 11 Jul 2017 14:32:35 GMT

Yes, I have checked P() and E() function in the expressions.

If "Maersk" is selected in this bar chart, that 5 fields to be displayed in a table and if "Cargosmart" is selected, 4 fields to be displayed in a table.

I couldn't achieve this drill-down because of using E() function.

Is there any way to achieve this also?

Re: How to compare fields

Anil_Babu_Samineni — Tue, 11 Jul 2017 14:55:17 GMT

I am confused again, This is the case why you need E() function?? Will you able to provide sample application?

Re: How to compare fields

Anonymous — Tue, 11 Jul 2017 17:09:06 GMT

Attached the sample file.

Re: How to compare fields

Anil_Babu_Samineni — Tue, 11 Jul 2017 17:15:35 GMT

Please explain now, If you are not selecting any thing report gets no data. If you select some thing what are you expecting? Please mention Numbers

Re: How to compare fields

Anonymous — Tue, 11 Jul 2017 17:19:36 GMT

If Hapag Lloyd is selected, I've got the exactly matched fields count of Cargosmart(4) and Maersk(5).

When it is drill-downed further i.e if Cargosmart is selected in the bar chart, I need to get that 4 fields and similarly for Maersk, 5 fields in a table and bar chart has to be hidden.

Could you please suggest some other way to achieve this?

Re: How to compare fields

Anil_Babu_Samineni — Tue, 11 Jul 2017 17:29:03 GMT

What my understand is If you are selecting Hapag Lloyd from Customer. You want to exclude that selection from Chart and the if we drill down or selection happen on Bar graph you want to get straight table like below, Is that you are looking?

Re: How to compare fields

Anonymous — Tue, 11 Jul 2017 17:33:31 GMT

Yes exactly it is what I'm looking. When I select the customer in bar chart alone, I don't want to exclude it.

Is this possible to do?

Re: How to compare fields

Anil_Babu_Samineni — Tue, 11 Jul 2017 17:44:33 GMT

I wonder, How we are manipulating hide and show objects for Exclude function. Let them reply stalwar1‌mrkachhiaimp‌cleveranjos‌

Re: How to compare fields

sunny_talwar — Tue, 11 Jul 2017 18:42:52 GMT

May be like attached

Re: How to compare fields

Anonymous — Tue, 11 Jul 2017 19:15:05 GMT

But I want to get the exact fields count in the table also.

If the bar with value 4 is selected, then it should be showing the exact 4 fields. Please assist me for this also, Sunny.

Thanks,

Siva.

Re: How to compare fields

sunny_talwar — Tue, 11 Jul 2017 19:30:10 GMT

Check now

Re: How to compare fields

Anonymous — Tue, 11 Jul 2017 20:00:46 GMT

Great Thanks Sunny. This has been a long time issue for me, but you have cleared it just like that.

Could you please explain this expression in detail since I'm not clear on it?

Thanks,

Siva.

Re: How to compare fields

Anonymous — Tue, 11 Jul 2017 20:03:43 GMT

Thank you so much Anil for helping me to solve this.

Regards,

Bose.

Re: How to compare fields

sunny_talwar — Wed, 12 Jul 2017 01:01:15 GMT

Is there a specific thing you don't understand? Might be easier for me to explain something you don't understand rather than going over each and everything

Re: How to compare fields

Anonymous — Wed, 12 Jul 2017 09:16:36 GMT

Is this possible for grouped bar chart? On selecting each bar in grouped bar chart, can we do this same by using your expression.

Re: How to compare fields

sunny_talwar — Wed, 12 Jul 2017 11:11:17 GMT

I think it should be possible, I have not tried and tested it. Give it a shot and let us know if it worked or not