topic Creating calculated values as Dimension in QlikView

Creating calculated values as Dimension

Anonymous — Tue, 06 Mar 2018 20:11:09 GMT

Hello everybody, I am totally confused about my QlikView Application.

I'll try to calculated values for a Report. Therefore I have different sources, joined them and now I calculate the values in a PivotTable.

I want to count the number of Names listed for one ID.

Therefore I made an Expression Field Count(Distinct TOTAL <Employee_ID> Coursename). The results are right. But I get all the results as often as the name exists.

So I tried to calculate a dimension with Aggr(Count(Distinct TOTAL <Employee_ID> Coursename), Employee_ID). Around 90% of the values are correct, but some of them aren't. I dont know why and tried nearly everything since three days.

Re: Creating calculated values as Dimension

isingh30 — Tue, 06 Mar 2018 20:40:01 GMT

Please share your data or app.

Thank you!

Re: Creating calculated values as Dimension

Digvijay_Singh — Tue, 06 Mar 2018 20:57:37 GMT

What do you get from this -

Aggr(Count(Distinct Coursename), Employee_ID)

Didn't understand this below?

But I get all the results as often as the name exists.

Re: Creating calculated values as Dimension

Anonymous — Wed, 07 Mar 2018 09:07:20 GMT

I tried to explain that issue in the Picture below. I want to count the number of trainings completed for each ID. As Expression the values are right. When I try to use a Dimension with Aggr I get nearly the right values, but around 10% of the values are incorrect.