topic Re: help needed in solving this requirement in QlikView

help needed in solving this requirement

fashid — Mon, 14 Apr 2014 08:48:44 GMT

Hi,

This is in reference to my Previous post over here Urgent help required in solving this problem

I am facing an issue in solving this requirement. i need to find the percentage of the no of days elapsed

eg the calculation should be as:-- the difference between the 'difference' column where SMS TYPE is 4 and SMS TYPE is 2 divided by

the difference column where SMS TYPE is 2 for a particular DOC NO

for eg:-- in the qvw app that i have attached, in the bottom most chart for do3 DOC NO the calculation should be

(4-2)/2*100 (I am referring to the difference column) in the bottom chart

Thanks And Regards

SHaikh Nadeem

Re: help needed in solving this requirement

fashid — Mon, 14 Apr 2014 14:38:56 GMT

Hi,

I have worked on the above and produced the required output using the expression "IF([SMS TYPE]=4,(difference-Above(TOTAL (difference)))/Above(TOTAL (difference)))"

Now if anybody could just help me out in averaging the values in the percentage column considering only KVPS i Have tried to do that but failed

If you need any clarification please let me know

Regards

Shaikh nadeem

Re: help needed in solving this requirement

fashid — Sun, 20 Apr 2014 07:33:15 GMT

Can Anybody please reply

Re: help needed in solving this requirement

PrashantSangle — Sun, 20 Apr 2014 07:41:38 GMT

Hi,

can you tell me ,What is your expected output in % column?

Regards,