Average

[#1]

Hi, I want to get 12% in the last of Avg but its giving 1%, is there any possibility to get 12% Avg in last.

Contacts Average

1 10%

2 2%

3 0

to

14 0

______

1%

Regards,

Khalid

[#2]

Hi,

Can you please post sample data in exceal with output whihc your expecting out that.

-Peterson

[#3]

Thanks so nice of you, I found its solution in Reference Manaual.

I have a question that can we do the expression given below through Set Analysis:

=Sum ( Aggr ( Sum ( Sales ) , Country , TransCCY ) )

Regards,

[#4 · Accepted solution]

Hi,

Major use of set analysis is different.

You are trying to sum up the sales with respect to country and TransCCY. There is no use of set analysis here.

-Peterson

[martin59]

Hello,

I don't understand what you want with this expression. Why don't you that :

sum(Sales)

Martin

[#6]

Ok fine I understood, I found very good example of fuction aggr() in Reference Manaual when i clicked sum - of - rows totals in a Pivot Table . it shows chart Table with explanation and equation that kind of example I want for Set Analysis. Can you arrange a similar kind of example for Set Analysis in PDF format or an Application example.

I also checked in Reference Manaual it has good explanation of Set Analysis but it has not example like aggr() function.

Regards,

Khalid

[martin59]

Look at the attachement and tell me if it's enough to understand.

[#8]

Thanks, this was very helpful.

[#9]

Hi,

If I am using a 32bit QlikView Application and if I want to upgrade it to 64bit QlikView Application so what is the procedure for doing it. Do I have to pay it or have to purchase a new license for it? Please to let me know what is the policy of QlikView.

Regards,
Khalid

[martin59]

You have nothing to do, just download the 64-bit executable and install-it. It's the same licence, and same applications.

Martin