Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Cross Filtering in Survey Data

Hi,

I have conducted a survey and stored the data using star schema.

My fact table looks like this..

   

ResponseIDQuestion_IDAnswer_ID
1Q11
1Q22
1Q34
1Q41
2Q15
2Q21
2Q31
2Q41
3Q11
3Q21
3Q31
3Q41
4Q11
4Q22
4Q32
4Q41

I have 4 charts, each one for a question.

Requirement: When I select chart 1 for a response (lets say I selected Answer_ID=1), I want to show all the response_IDs in chart 2,3,4 that answered '1' in Q1.

Current situation: When I selected Answer_ID=1, it filters the whole data set with (Question_ID =Q1 & ANswer_ID=1) and blanks all other charts.

I want filtering within rows instead of columns. One of achieving this is to make all the questions a 'dimension' but I will lose my schema in that case.

Does anybody have a solution for this?

Thanks

Mike