Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Perform calculations post filtering the data

Hi All,

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.

Thank You.

0 Replies