Field combination

[#1]

Hello Everyone,

I'm new to QlikView and on this forum and i hope you can help me.

I'll try to explain my problem in the simplest way possible with an illustration.

Let's say i have at my disposal a population defined by four variables: Age class, socio-professional category, gender and salary.

What i try to do is to determine the socio-demographic profile for which the salary is the highest.

The result i'm trying to get is of the type "The men of 25-35 years practicing law have the highest salary ".

If i were to find this result "by hand", i'd have to test all possible combinations of the values of the first 3 variables (age class, socio-professional category, and gender) and calculate for each combination, the average salary. Naturally, the greater the number of variables, the greater the number of combinations.

i would like to know if there is a way to achieve this in QlikView, without having to go through every combination.

Don't hesitate to ask for clarification if my question is not clear

Thanks in advance for your help

[ramasaisaksoft]

Hi yerim,

Your question is need to clear with some sample data (if possible create an excel )and also mention the output what you need to see in QV.

so that we will give solutions perfectly.

i hope you are asking aggr().

[marcus_sommer]

I would very probably start such task by creating an age-cluster per calculated dimension like:

aggr(class(age, 10), gender, profession)

within a pivot-chart and adding gender and profession as dimension and using then expressions like:

min/max/avg(salary)

I think if you played with them a bit you will see many more possibilities to get answers to your questions.

- Marcus

[#4]

Thanks for your answers!

I started looking into aggr() and it looks like it could help me get there.

I'll play with it a little and then come back to you if i still can't find a suitable solution

Thanks a lot for your reactivity

[#5]

I used the aggr() function and it answers to all my needs!

Thanks a lot for your help

[#6]

One last question before i mark this topic as resolved.

Is there a way to put on screen the temp table created when using the aggr() function?

So far, i can pretty much get any information i want from that table but i can't seem to be able to extract the whole table in which all of these informations are stored. Is it possible?

Thanks in advance for your answer

[marcus_sommer]

You could built such a table by using a straight table with the dimensions which are included in the aggr and applying the inner aggr-expression to this table.

- Marcus

[#8]

Thanks a lot. It works perfectly 🙂