Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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