topic Re: Calculated Dimension in QlikView

Calculated Dimension

Mario_ES — Tue, 26 Oct 2021 10:26:32 GMT

Hello,

I'm trying to create a table with employee code, name, last name and degree. The problem is that some eployees have more than 1 degree so they appear multiple times.

I only want it to show the unique employee code with their highest degree.

I have tried to use calculated dimensions but so far I only get errors.

Re: Calculated Dimension

stevejoyce — Tue, 26 Oct 2021 11:01:39 GMT

If employee code can only have one name & last name you can have degree as a calculated dimension. But this is easier to do by using a single expression in your table to control what values to display and display like a "x". But as a calculated dimension, try making degree as:

aggr(aggr(max(degree), [employee code]), degree)