Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Using OR relationship between filters and grouping the results in one row in a pivot table

Hello Qlikkers,

I have a dataset where there exists one to many relationship between the fields- PersonID and Cinema1, Cinema2, Cinema3 and Cinema4-


Now, I want to have filters in the app where users can choose any cinema from any of the four fields (cinema1,cinema2,cinema3,cinema4) and see the results grouped together in one row. e.g, if a user chooses 'AAA' from fields cinema1 and cinema2, all the PersonID who have AAA in cinema1 AND/OR cinema2 will be grouped together in one row-


For example- in the above picture I want to see all the cases of female with cinemas AAA in any of the four fields grouped in one row. Here, I cannot select the 'AAA' for other cinema fields because it has already filtered out the cases based on the first filter.

I am attaching the dataset and dummy app for reference here. Any suggestions regarding the problem is highly appreciated. Thank you.

Labels (2)
3 Replies

You might want to create another table in your load script that restructures the cinema fields.

Load * inline [

For i = 1 to 4

  Concatenate (Cinemas)
  Load 'Cinema'&'$(i)' as Cinema,
   Cinema$(i) as CinemaValue,
  Resident Dataset;
next i;

And then filter and group on the CinemaValue field in the presentation.

Contributor III
Contributor III

Hi Gary,

Thank you for your response. But unfortunately, this is not working because of the complex data model. Since, the result I want to see in the table includes other fields from the main table (CinemaStratum,CinemaPSU and UtilityWt) as well. For example-


It is no longer calculating the standard errors. I am attaching the updated app.

Contributor III
Contributor III

What I am really looking for is dimension grouping in the front end-

dimension groupingdimension grouping