topic Re: help ! needed in creating a formula in QlikView

help ! needed in creating a formula

fashid — Wed, 05 Nov 2014 14:02:38 GMT

Hi,

I am stuck with a formula to create

The formula is conversion efficiency:-

=sum({<[MARA.Material Type_MTART]={'HALB'}>}[VEKP.Loading volume_NTVOL])/50832*100

the Problem is that if the user selects 3 days, the denominator should get multiplied by 3, the same should happen if the user just selects a single month then the denominator should get multiplied by 30 or 31 depending on the month in the master calendar.

How do i go about doing this

Thanks & regards,

Nadeem

Re: help ! needed in creating a formula

Anonymous — Wed, 05 Nov 2014 14:05:39 GMT

Hi ,

You better create a aditional static column repeated for each row in calendar table.

like 1 as addtional column in script. Afte that you use the sane column in denominator. Just take the sum/count of that column. if you select a month, it will take count for possible numbers.

this should do.

just

Regards,

Chinna

Re: help ! needed in creating a formula

marcus_sommer — Wed, 05 Nov 2014 16:31:12 GMT

Try: YourExpression / count(distinct date)

- Marcus

Re: help ! needed in creating a formula

fashid — Thu, 06 Nov 2014 12:20:19 GMT

Thanks a lot , without you guys it would be just so difficult

Re: help ! needed in creating a formula

fashid — Thu, 06 Nov 2014 13:09:51 GMT

Thank you for taking out your time to reply