Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

This may be a little hard to describe

I have four columns - A current allocation percentage, proposed allocation percentage, and a weight for specific types of classes.  Note the last class should be a subtraction of whatever is left over from 100.  So for example:

CLASS  ALLOCATION  PROPOSED  WEIGHT

C1                A                      =A*W              W

C2                A2                    =A*W2            W

C3                A3                    Whatever's Left Over out of 100

C1               25                      3.75                 .15

C2               40                      18                    .45

C3               35                      78.25              N/A

I'm having trouble with the calculation of the underlined column.  Any ideas?

2 Replies
Clever_Anjos
Employee
Employee

Not sure about your exact requirement, please find attached a possible solution

sinanozdemir
Specialist III
Specialist III

Hi Kevin,

I cannot open cleveranjos solutions since I only have the personal edition, but here is my approach which is not so elegant:

I also put weights into variables.

Capture.PNG

Again, this is based on the data you provided. If there are more classes, then the script needs to be adjusted accordingly. I am also attaching my qvw.

Hope this helps.