Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Can you please post sample data in exceal with output whihc your expecting out that.
-Peterson
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,
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
Hello,
I don't understand what you want with this expression. Why don't you that :
sum(Sales)
Martin
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
Look at the attachement and tell me if it's enough to understand.
Thanks, this was very helpful.
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
You have nothing to do, just download the 64-bit executable and install-it. It's the same licence, and same applications.
Martin