Qlikview Dimension

melissayzy — Thu, 23 Jul 2020 16:43:15 GMT

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

Re: Qlikview Dimension

rubenmarin — Sat, 25 Jul 2020 09:28:37 GMT

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)

topic Qlikview Dimension in QlikView

Qlikview Dimension

Re: Qlikview Dimension