topic Re: calculating Ratio on conditional level in QlikView

calculating Ratio on conditional level

Wed, 30 Sep 2015 06:47:37 GMT

Hi All,

We have data to the granularity of Week level .

we have a requirement where

if value of A is less then value B for that week then we need to add achieve= achieve +1 for that week .considering achieve as 0

and in final output we need to show achieve/52 . total count of achieve by number of weeks in year .

This needs to be shown at YTD , mtd and month and week level .

How can I achieve this requirement .

Do we need to do calculation in script or can we handle it in frontend

Thanks

Kushal_Chawda — Wed, 30 Sep 2015 07:02:50 GMT

Please share the sample file with required ouptput

Wed, 30 Sep 2015 07:17:46 GMT

Hi Kush ,

thanks for the reply .

So here it goes .

We have some target define at weekly level.

These target are performed .

if the target performed is greater then the target given we consider it as a more then expected . and assign it value 1 for that week otherwise 0

so in total it would be 52 weeks in an year .

we need to calculate the total expected and then divide it by 52. that would be the expected output .

I will try to upload a sample file

thanks