How to analyze data based on possible value in field x , due to selection in field y ?

[prahlad_infy]

Hello Sirs ,

How to analyze data depending on possible value in field x , due to selection in field y ?

Business Case

The moment i select any Area , i should get its corresponding Region (which i gotted already)...

1) Chart with sales of all the area falling under corresponding zone

2) Chart with two bars - one bar showing sale of selected Area while another bar showing sale of  that area which is having highest sale under corresponding region

Simple example

On selection of  Area A1 , i should get a sales bar graph oF all the Area under Region R1 as A1 is under Region R1

On selection of  Area A1 , i should get a sales bar graph oF for Area A1 and A7,A8 as both have highest sales values under Region R1

Data is inline load .

Thank you .

[prahlad_infy]

Sir can you please help . You help me last time i remember .

stalwar1‌

[dplr-rn]

Hi

did you try below approach

Sum( {<Area=,Region=P(Region)>}  Sales)

[neelamsaroha157 · Accepted solution]

Is this what you were looking for ?

[prahlad_infy]

Thank You Sir . It helped for one requirement .

If you can Please explain P and E function , i always tried to understand it gets more confusing

[prahlad_infy]

Thank You Mam

[prahlad_infy]

A slight change actually i want A1 A7 A8 without selection of R1 in Region .. just selection of A1 in area should give me that result

[dplr-rn]

P is basically possible values for a field and E is excluded

in the expression i shared i am getting all possible values of region (which when A1 is selected is R1)

they are useful.

for your problem you may need to use them plus the solution from neelam

more is available https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-mod...