I have requirement where based on the values selected in prompts on dashboard page the data should get filter from the main source table and then that table need to be joined with other tables and calculations need to be performed based on the new set created. For example:
Table A has base data.
User selects Prompt1 and Prompt2 from dashbaord page. So first these filter should get applied to Table A as "Select * from Table A where A.Columm1 in (Prompt1) and A.Column2 in (Prompt2).
Lets the above data set is Table B.
Now Table B needs to be inner joined with Table C and then based on the new data set we perform the calculations.
Need opinion on what could be the best way to achieve this in Qlikview. Please advise.