topic Re: Aggr / Only functions problem in QlikView

Aggr / Only functions problem

Sun, 29 Nov 2015 09:36:11 GMT

Hello,

I have a table that contains field, agent, date, grade and others.

In the dimensions i have a cycle with field+agent. I need to add the grade of the maximum date that had been chosen.

HOW CAN I GET THESE:

The cycle for agent should look like:

agent grade num of agents

1 3 1

2 4 1

The cycle for field:

field grade num of agents

A 3 4

2 3

1 4

B .....

I tried to do only func with a set analysis but it didnt work for the fields.

i tried to use AGGR func, but it didnt work to.

Do you have any ideas?

swuehl — Sun, 29 Nov 2015 15:04:36 GMT

Please post a more detailed description of your data model, dimensions and expressions used in that chart.

Best by uploading a small sample QVW.

Kushal_Chawda — Sun, 29 Nov 2015 15:41:22 GMT

try this calculated dimension in cyclic group

=aggr(Only({<Date={"$(=date(max(Date)))"}>}grade), agent)

Mon, 30 Nov 2015 07:29:52 GMT

It's works for the agent but not for the field.

Thank you anyway