Comparison of data

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

Hi,

I want to show comparative data based on a selection from filter eg: Customer. Let's assume we have the below 3 customers.

Customer Field Name

A AD

A BG

A BM

B AD

B BK

B BM

C KL

C BG

C SR

and if customer A is selected, I want a bar chart data as shown below. I got this bar chart but when I select data in the chart, it needs to show that data in a table - I could not achieve this part. For example, if Customer B is selected in the bar chart, it has to show those 2 fields of customer B.

But the problem I'm facing here is, I have used E() function - and there were two selections made for the same dimension - so if any data selection is made in the bar chart, it shows excluded data in the table due to E() function.

All help appreciated.

Attached QVW file and sample data.

Regards,

Siva

Re: Comparison of data

sunny_talwar — Tue, 14 Aug 2018 19:44:02 GMT

May be use alternate state to do this. Check attached

Re: Comparison of data

Anonymous — Tue, 14 Aug 2018 21:11:13 GMT

Thanks, Sunny. Much appreciated.

topic Re: Comparison of data in QlikView

Comparison of data

Re: Comparison of data

Re: Comparison of data