Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
abhinavbose
Creator III
Creator III

Comparison of data

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.


Comparison.jpg

  All help appreciated.

Attached QVW file and sample data.

Regards,

Siva

1 Solution

Accepted Solutions
sunny_talwar

May be use alternate state to do this. Check attached

View solution in original post

2 Replies
sunny_talwar

May be use alternate state to do this. Check attached

View solution in original post

abhinavbose
Creator III
Creator III
Author

Thanks, Sunny. Much appreciated.