topic Re: Field combination in QlikView

Field combination

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Field combination

ramasaisaksoft — Tue, 03 May 2016 12:45:58 GMT

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().

Re: Field combination

marcus_sommer — Tue, 03 May 2016 14:10:52 GMT

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

Re: Field combination

Tue, 03 May 2016 14:18:40 GMT

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

Re: Field combination

Tue, 03 May 2016 15:38:45 GMT

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

Thanks a lot for your help

Re: Field combination

Wed, 04 May 2016 12:57:31 GMT

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

Re: Field combination

marcus_sommer — Wed, 04 May 2016 18:30:55 GMT

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

Re: Field combination

Fri, 06 May 2016 06:59:34 GMT

Thanks a lot. It works perfectly 🙂