Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
HereWeGoAgain
Contributor III
Contributor III

IF condition

Hi Guys

I want to create a formula which looks for all outstanding paperwork in %. so the formula will need to look at all oustanding paperwork(at any date range), then taking the value of the oustanding paperwork and then dividing it by current month's revenue.

Oustanding paperwork: LoadSendToInvFlag='N'

Revenue: DrValue

current month: [LoadDate.autoCalendar.Date]

Hope this makes sense.

Thanks in Advance

 

1 Solution

Accepted Solutions
anthonyj
Creator III
Creator III

Hi,

I'm assuming that there are other values in LoadSendToInvFlag so we can use set analysis to limit it to just the 'N'.

The LoadDate is looking at the month of the last load date (ie today(0)) to return your dynamic value.

count({$<LoadSendToInvFlag={'N'}>}[LoadSendToInvFlag]) / sum({$<LoadDate={">=$(=monthstart(today(0)))"}>}DrValue)

I hope this is in the ballpark of what you were looking for.

Regards

Anthony

View solution in original post

2 Replies
anthonyj
Creator III
Creator III

Hi,

I'm assuming that there are other values in LoadSendToInvFlag so we can use set analysis to limit it to just the 'N'.

The LoadDate is looking at the month of the last load date (ie today(0)) to return your dynamic value.

count({$<LoadSendToInvFlag={'N'}>}[LoadSendToInvFlag]) / sum({$<LoadDate={">=$(=monthstart(today(0)))"}>}DrValue)

I hope this is in the ballpark of what you were looking for.

Regards

Anthony

HereWeGoAgain
Contributor III
Contributor III
Author

@anthonyj Thank you!