Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fashid
Specialist
Specialist

help ! needed in creating a formula

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

1 Solution

Accepted Solutions
marcus_sommer

Try: YourExpression / count(distinct date)

- Marcus

View solution in original post

4 Replies
Anonymous
Not applicable

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

marcus_sommer

Try: YourExpression / count(distinct date)

- Marcus

fashid
Specialist
Specialist
Author

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

fashid
Specialist
Specialist
Author

Thank you for taking out your time to reply