Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
melissayzy
Contributor
Contributor

Qlikview Dimension

Hi, 

I have a question about dimension. In a chart table, I have three dimensions A, B and C(each corresponds to a field). There are many more fields in my data besides A, B, C and users can select and filter values for any field. Now, I want to apply user's current selected values only for A field and B field but not any other. All other fields' selections should be ignored. In my chart table, I want to have A, B as dimensions and then C as my third dimension so that each c field value satisfying A&B selections should be an individual row. How should write the calculated dimension for C? I don't want aggregation functions like sum()or count() as I simply want to display all c values. Is it feasible? 

 

Thanks,

Melissa

1 Solution

Accepted Solutions
rubenmarin

Hi, I'm not sure if you can do that in a calculated dimension, but you can use A and B as dimensions and show C as expression using:

Only({<C>} C)

View solution in original post

1 Reply
rubenmarin

Hi, I'm not sure if you can do that in a calculated dimension, but you can use A and B as dimensions and show C as expression using:

Only({<C>} C)