topic Re: Can anyone help me simplify the calculation? in QlikView

Can anyone help me simplify the calculation?

Wed, 13 Aug 2014 11:12:42 GMT

I have a calc like this :

=( Grade1/Garde 1 std) + (Grade2/Garde2standard)+...............................+ (Grade10/Garde10standard)

For today its 10 what if tomorrow there are many standards. Can you help me with the best solution. And this is the expression calc you can either advise me in data modelling (Scripting)wise or else in expression wise as well.

Jagan Mohan Ashfaq Mohammed John Witherspoon

Re: Can anyone help me simplify the calculation?

juleshartley — Wed, 13 Aug 2014 11:19:47 GMT

You could build the expression in the script using a loop and a variable.

let vFormula = (Grade1/Grade1standard);

For i = 2 to 10

Let vFormula = $(vFormula) & ' + Grade' & i & '/Grade' & i & 'standard)'

Then use vFormula in the script. You may have to be careful with apostrophe's and use chr(39) etc.

Re: Can anyone help me simplify the calculation?

juleshartley — Wed, 13 Aug 2014 11:20:38 GMT

ps. You can of course replace the 10 with a count of the possible options to make it dynamic...

Re: Can anyone help me simplify the calculation?

Wed, 13 Aug 2014 11:24:18 GMT

But for static this is fine,

What if I have many calcs and selections considered

Ex : = Count(<Type = super,order='check'Grade1>/(Garde 1 std) + Count(<Type = super,order='check'>Grade2)/(Garde 2 std) . I think its better to write a big calc just heard from business team there is only 10 standards always.

Just thinking...........................................