Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Is this what you were looking for ?
Sir can you please help . You help me last time i remember .
Hi
did you try below approach
Sum( {<Area=,Region=P(Region)>} Sales)
Is this what you were looking for ?
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
Thank You Mam
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
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...