Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two pivot tables in named by continent & by plant. When I should select a plant from filter, in the continent table it should give me result for respected continent along with description. For example : If I select a plant Shanghai Cutting then Continent table should give me the values for Asia region not only for Shanghai Plant.
Similarly, in the plant table, it should give only plant related information regardless of Continent.
Please find attached reference file for your reference.
Thanks in advance.
Hi Piyush,
Use p function to get possible value.
Use this expression in your first chart
=Sum({<FieldID={'400','413','449'},[Month] ={"<=$(=GetFieldSelections([Month]))"},Continent= p(Continent),[Plant Name]= >}Actual)
in the plant table, it should give only plant related information regardless of Continent. (Clarify)
Hi Piyush,
We use p function to get possible values of a field. You can only use p() in a set analysis set modifier.
when you are selecting Plant Name 'Shanghai Cutting', It will return Continent Asia. I am just picking that Continent data using p function regardless whatever plant is selected. And bypassing the Plant name will generate full data set of that Continent.
for better understanding follow this post: https://community.qlik.com/t5/QlikView-App-Development/P-E-and-where-do-you-use-them/td-p/457847.
For Plant, it should give me information related to plant regardless whatever continent is selected.
Bypass Plant Name in your second chart like this-
sum({<FieldID={'400','413','449'},[Month] ={"<=$(=GetFieldSelections([Month]))"},Continent=>}Actual)
what we select in Continent Field it will not effect second chart.
Please make it correct answer if it is working. 🙂
Hi Piyush,
Just check your data model, Qlikview has associative model functionality. So if you have continents along with your plants in the data itself, then it will definitely works on both tables.
-Shubham
Hi Piyush,
Use p function to get possible value.
Use this expression in your first chart
=Sum({<FieldID={'400','413','449'},[Month] ={"<=$(=GetFieldSelections([Month]))"},Continent= p(Continent),[Plant Name]= >}Actual)
in the plant table, it should give only plant related information regardless of Continent. (Clarify)
Hi Prabir_c,
Thanks for quick reply.
For Plant, it should give me information related to plant regardless whatever continent is selected.
Also could you please let me know what will p() function
Thanks.
Hi Piyush,
We use p function to get possible values of a field. You can only use p() in a set analysis set modifier.
when you are selecting Plant Name 'Shanghai Cutting', It will return Continent Asia. I am just picking that Continent data using p function regardless whatever plant is selected. And bypassing the Plant name will generate full data set of that Continent.
for better understanding follow this post: https://community.qlik.com/t5/QlikView-App-Development/P-E-and-where-do-you-use-them/td-p/457847.
For Plant, it should give me information related to plant regardless whatever continent is selected.
Bypass Plant Name in your second chart like this-
sum({<FieldID={'400','413','449'},[Month] ={"<=$(=GetFieldSelections([Month]))"},Continent=>}Actual)
what we select in Continent Field it will not effect second chart.
Please make it correct answer if it is working. 🙂
Hi Prabir_c
Could you please also help me for the post subjected "Month name from January to December " posted couple of days back.
Thanks
Hi Prabir_c,
Could you please look into my issue posted with title " Help required for Filter "
Thanks in advance